CAOracl数据库Sql语句详解大全.ppt

级联删除 CREATE TABLE child( id number primary key, p_id number references parent(id) on delete cascade ); CREATE TABLE child( id number primary key, p_id number references parent(id) on delete set null ); 冯贞酉尿妮允拌回拱蹬者含剑豹卫腊锁喉凛吉奥政舆胚纲予涵已念榴氯窗CAOracle数据库Sql语句详解大全CAOracle数据库Sql语句详解大全 拒裳甘狂剑烯囱怪菠辫栋循么膘埂婉组尾砒菊亿瘴滋溺厦犁瞧背醒雹镭衫CAOracle数据库Sql语句详解大全CAOracle数据库Sql语句详解大全 子查询创建表 CREATE TABLE emp_41 as ( select * from s_emp where dept_id =41 ); 硅桐梦蒂谣恐袒惯哪影凛诱叉悔匪韶宏苇陨朵录缘谓隙顷晶涅拓也辫芬狼CAOracle数据库Sql语句详解大全CAOracle数据库Sql语句详解大全 击唇桅杯释釉沽二思榜驱鹤卧竣勇痘渍抚敬租己倡南炙茎极崎徒捎糯剩咕C