ORACLEʹÓÃEXCEPTIONS±í²éѯ³ö±íÖÐÖظ´¼Ç¼

SQL> conn system/oracle
Connected.
SQL> create table scott.t1(id number primary key,name varchar2(10)); --´´½¨²âÊÔ±í
Table created.
SQL> select constraint_name,table_name,constraint_type, --²é¿´ÏàÓ¦ÍêÕûÐÔÔ¼ÊøµÄ״̬
  2  status,deferrable,deferred,validated
  3  from dba_constraints
  4  where owner='SCOTT' and table_name='T1';
CONSTRAINT_NAME                TABLE_NAME                     C STATUS
------------------------------ ------------------------------ - --------
DEFERRABLE     DEFERRED  VALIDATED
-------------- --------- -------------
SYS_C0023319                   T1                             P ENABLED
NOT DEFERRABLE IMMEDIATE VALIDATED
SQL> insert into scott.t1 values(1,'tt');
1 row created.
SQL> insert into scott.t1 values(1,'hh');  --²åÈëidÁÐÖظ´µÄ¼Ç¼ʧ°Ü
insert into scott.t1 values(1,'hh')
*
ERROR at line 1:
ORA-00001: unique constraint (SCOTT.SYS_C0023319) violated
SQL> alter table scott.t1 disable novalidate constraint SYS_C0023319;  --ÐÞ¸ÄÔ¼Êø״̬
Table altered.
SQL> select constraint_name,table_name,constraint_type,  --²é¿´ÏàÓ¦ÍêÕûÐÔÔ¼ÊøµÄ״̬
  2  status,deferrable,deferred,validated
  3  from dba_constraints
  4  where owner='SCOTT' and table_name='T1';
CONSTRAINT_NAME                TABLE_NAME                     C STATUS
--------