oracle查詢存儲過程依賴的表 oracle怎么用觸發(fā)器刪除依賴關(guān)系的表的數(shù)據(jù)?
oracle怎么用觸發(fā)器刪除依賴關(guān)系的表的數(shù)據(jù)?--項(xiàng)目編號,地址varchar2(100),電話varchar2(12))--項(xiàng)目編號:TB(項(xiàng)目編號,名稱varchar2(20),貨幣編號(12,
oracle怎么用觸發(fā)器刪除依賴關(guān)系的表的數(shù)據(jù)?
--項(xiàng)目編號,地址varchar2(100),電話varchar2(12))--項(xiàng)目編號:TB(項(xiàng)目編號,名稱varchar2(20),貨幣編號(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)其他人提高效率/