外码

SQL*Plus: Release 10.1.0.2.0 - Production on 星期四 6月 2 18:13:18 2011 Copyright (c) 1982, 2004, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production With the Partitioning, OLAP and Data Mining options SQL> conn ymc/ymc Connected. SQL> ed Wrote file afiedt.buf 1 CREATE TABLE father( 2 id CHARACTER PRIMARY KEY 3* ) SQL> / Table created. SQL> ed Wrote file afiedt.buf 1 CREATE TABLE child( 2 id CHARACTER PRIMARY KEY, 3 fa REFERENCES father(id) 4* ) SQL> / Table created. SQL> ed Wrote file afiedt.buf 1 BEGIN 2 INSERT 3 INTO father 4 VALUES('1'); 5 INSERT 6 INTO father 7 VALUES('2'); 8* END; 9 / PL/SQL procedure successfully completed. SQL> ed Wrote file afiedt.buf 1* SELECT * FROM father SQL> / I - 1 2 SQL> ed Wrote file afiedt.buf 1 BEGIN 2 INSERT 3 INTO child 4 VALUES('1','1'); 5 INSERT 6 INTO child 7 VALUES('3','1'); 8 INSERT 9 INTO child 10 VALUES('5','1'); 11 INSERT 12 INTO child 13 VALUES('2','2'); 14 INSERT 15 INTO child 16 VALUES('4','2'); 17 INSERT 18 INTO child 19 VALUES('6','2'); 20* END; SQL> / PL/SQL procedure successfully completed. SQL> ed Wrote file afiedt.buf 1* SELECT * FROM child SQL> / I F - - 1 1 3 1 5 1 2 2 4 2 6 2 6 rows selected. SQL> ed Wrote file afiedt.buf 1 DELETE 2 FROM father 3* WHERE id = '1' SQL> / DELETE * ERROR at line 1: ORA-02292: integrity constraint (YMC.SYS_C005423) violated - child record found SQL>

原来外码的列级定义是这样的；

子表引用父表；

默认的动作是 no action，既不允许操作，要先删子表再删父表