Thanks for the question, Radha Sri Seshu.
Asked: July 25, 2017 - 11:16 am UTC
Last updated: July 25, 2017 - 1:24 pm UTC
Version: 11.2
Viewed 1000+ times
CREATE TABLE A(NO1 NUMBER(2) PRIMARY KEY,NO2 NUMBER(2)); CREATE TABLE B(NO1 NUMBER(2) PRIMARY KEY,NO2 NUMBER(2)); ALTER TABLE A ADD CONSTRAINT AA FOREIGN KEY(NO2) REFERENCES B(NO1); ALTER TABLE B ADD CONSTRAINT BB FOREIGN KEY(NO2) REFERENCES B(NO1) deferrable initially deferred; INSERT INTO B VALUES(10,20); INSERT INTO A VALUES(20,10); select * from a; NO1 NO2 20 10 select * from b; NO1 NO2 10 20
INSERT INTO B VALUES(11,30); commit; ORA-02091: transaction rolled back ORA-02291: integrity constraint (CHRIS.BB) violated - parent key not found
Radha Sri Seshu Kolla, July 27, 2017 - 9:23 am UTC
New to good database design? Check out Chris Saxon's full fundamentals class.