oracle查詢存儲(chǔ)過(guò)程依賴的表 oracle怎么用觸發(fā)器刪除依賴關(guān)系的表的數(shù)據(jù)?
oracle怎么用觸發(fā)器刪除依賴關(guān)系的表的數(shù)據(jù)?--項(xiàng)目編號(hào),地址varchar2(100),電話varchar2(12))--項(xiàng)目編號(hào):TB(項(xiàng)目編號(hào),名稱varchar2(20),貨幣編號(hào)(12,
oracle怎么用觸發(fā)器刪除依賴關(guān)系的表的數(shù)據(jù)?
--項(xiàng)目編號(hào),地址varchar2(100),電話varchar2(12))--項(xiàng)目編號(hào):TB(項(xiàng)目編號(hào),名稱varchar2(20),貨幣編號(hào)(12,2))--項(xiàng)目創(chuàng)建或替換觸發(fā)器TR鍵DB_tabfore DELETEON tareference NEW AS NEW OLD AS OLD for EACH ROWDECLAREBEGINdelete TB where item=:舊.item當(dāng)其他人提高效率/