Oracle觸發(fā)器的寫(xiě)法有三種:行級(jí)觸發(fā)器、語(yǔ)句級(jí)觸發(fā)器和嵌套表觸發(fā)器。
NEW
和OLD
偽記錄。CREATE OR REPLACE TRIGGER trigger_name
BEFORE INSERT OR UPDATE OR DELETE ON table_name
FOR EACH ROW
BEGIN
-- 觸發(fā)器邏輯
END;
/
NEW
和OLD
偽記錄。CREATE OR REPLACE TRIGGER trigger_name
BEFORE INSERT OR UPDATE OR DELETE ON table_name
BEGIN
-- 觸發(fā)器邏輯
END;
/
NEW
和OLD
偽記錄。CREATE OR REPLACE TRIGGER trigger_name
BEFORE INSERT OR UPDATE OR DELETE ON table_name
FOR EACH ROW
DECLARE
TYPE nested_table_type IS TABLE OF table_name.column_name%TYPE;
nested_table nested_table_type;
BEGIN
-- 觸發(fā)器邏輯
END;
/
以上是Oracle觸發(fā)器的三種常見(jiàn)寫(xiě)法,根據(jù)實(shí)際需求選擇合適的觸發(fā)器類(lèi)型進(jìn)行編寫(xiě)。