Thanks for the question, Volker.
Asked: February 10, 2016 - 2:49 pm UTC
Last updated: February 10, 2016 - 4:26 pm UTC
Version: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit
Viewed 1000+ times
create table t1 (x primary key) as select rownum x from dual connect by level <= 10; create table t2 ( t1x int constraint fk references t1 (x) deferrable initially deferred ); insert into t2 values (0); set constraint fk immediate; SQL Error: ORA-02291: integrity constraint (CHRIS.FK) violated - parent key not found select * from t2 where not exists ( select * from t1 where x = t1x ); T1X ---------- 0
Volker Bach, February 10, 2016 - 4:28 pm UTC
Share and learn SQL and PL/SQL; free access to the latest version of Oracle Database!
Classes, workouts and quizzes on Oracle Database technologies. Expertise through exercise!