Mega Code Archive

 

Categories / Oracle PLSQL / Constraints

 

Create a table with unique deferrable initially immediate

SQL> SQL> SQL> create table inventory(   2  partno number(4) constraint partno_pk primary key deferrable initially immediate,   3  partdesc varchar2(35) constraint partdesc_uq unique deferrable initially immediate); Table created. SQL> SQL> SQL> drop table inventory; Table dropped. SQL> SQL> SQL>