oracle中设置关联删除
ALTER TABLE 子表 ADD (
CONSTRAINT 约束名
FOREIGN KEY (key)
REFERENCES 主表 (key)
ON DELETE CASCADE);
!-------------------------
SELECT No FROM CMN03M1 CONNECT BY PRIOR NO=PARENT_DPT_NO START WITH
NO=?
查詢多值
select * from TABLE_NAME WHERE KEY IN (?,?,?);
ALTER TABLE 子表 ADD (
CONSTRAINT 约束名
FOREIGN KEY (key)
REFERENCES 主表 (key)
ON DELETE CASCADE);
!-------------------------
SELECT No FROM CMN03M1 CONNECT BY PRIOR NO=PARENT_DPT_NO START WITH
NO=?
查詢多值
select * from TABLE_NAME WHERE KEY IN (?,?,?);