I would like to know the syntax for putting a table constraint as follows:
Create Table tmp(id number, name varchar2(13));
How do I put a constraint if id =100 then name must be 'Peter' . I dont want to make use of triggers.
Results 1 to 3 of 3
Thread: Table constraints
Click Here to Expand Forum to Full Width