demo06.sql

来自「Expert Oracle Database Architecture 9i a」· SQL 代码 · 共 9 行

create table p ( x int primary key );
create table c ( x references p );
insert into p values ( 1 );
insert into p values ( 2 );
commit;
insert into c values ( 2 );
prompt In another session: delete from p where x = 1;;