约束的延迟创建DEFERRABLE

说明约束延迟创建

SQL> create table t (id integer);

Table created.

SQL> alter table t add constraint id_pk primary key(id) deferrable initially deferred;

Table altered.

SQL> insert into t values(1);

1 row created.

SQL> insert into t values(1);

1 row created.

SQL> commit;

commit

*

ERROR at line 1:

ORA-02091: transaction rolled back

ORA-00001: unique constraint (SCOTT.ID_PK) violated

SQL> set constraint id_pk immediate;

Constraint set.

SQL> insert into t values(3);

1 row created.

SQL> insert into t values(4);

1 row created.

SQL> commit;

Commit complete.

SQL> select * from t;

        ID

----------

         3

         4

SQL> 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/15720542/viewspace-722880/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/15720542/viewspace-722880/