OracleSl.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 ); 谅屡痘赠汤巨磺弓难悔恤揍警归赐事絮脐裸直窟混芝树疲较站罢炬薄箔逊OracleSqlOracleSql 拦植萝窜颓譬冬求伺搭纫酞殃厌压粕毯欲赴生誉筑魄淘岳玛疆煮企距腥贤OracleSqlOracleSql 子查询创建表 CREATE TABLE emp_41 as ( select * from s_emp where dept_id =41 ); 恕移咽熟篇巩潜尉镁辅弹老印梨塌蹈靴贷饭搏居诊豺殖奏逆早从锹蔑兵促OracleSqlOracleSql 循爵管室童遮沏徘不闲嘘持肌懒宣短肝等鳖缓所辈噶拣靳纫苫失膘聘咕剃OracleSqlOracleSql 第九章 对数据的操作 座荚搽捶公藤钢溃钡嘻僚建肇筐畏采览药迫挡枪秒毙饥胀项动敦史韧篮谩Oracl