Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ALTER TABLE employee
- WITH NOCHECK ADD CONSTRAINT EMP_SEX
- CHECK (Sex in ('M','F'));
- ALTER TABLE Account
- WITH NOCHECK ADD CONSTRAINT chk_account_type CHECK (Type IN ('saving', 'credit', 'HOME LOAN', 'PERSONAL LOAN', 'TERM DEPOSIT', 'CHECK', 'ISAVER', 'SHARE' ));
- SQL> ALTER TABLE employee
- WITH NOCHECK ADD CONSTRAINT EMP_SEX
- CHECK (Sex in ('M','F'));
- 2 3 WITH NOCHECK ADD CONSTRAINT EMP_SEX
- *
- ERROR at line 2:
- ORA-01735: invalid ALTER TABLE option
- ALTER TABLE Account
- ADD CONSTRAINT chk_account_type CHECK ( Type = 'a'));
- SQL>
- SQL> create table t(
- 2 i_has_cheezburger varchar2(20)
- 3 );
- Table created.
- SQL>
- SQL> alter table t
- add constraint check_burger check(i_has_cheezburger = 'CHEEZBURGER');
- Table altered.
- SQL>
- SQL> insert into t values('CHEEZBURGER');
- 1 row created.
- SQL> insert into t values('TOMATOES');
- insert into t values('TOMATOES')
- *
- ERROR at line 1:
- ORA-02290: check constraint (RNBN.CHECK_BURGER) violated
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement