What do you want to save?
Add Code snippet
New code examples
-
SQL 2022-02-11 13:10:37
pl sql trigger determine if insert or update or delete
CREATE OR REPLACE TRIGGER Audit_emp AFTER INSERT OR UPDATE OR DELETE ON Emp_tab FOR EACH ROW DECLARE Time_now DATE; Terminal CHAR(10); BEGIN -- get current time, and the terminal of the user: Time_now := SYSDATE; ... Add solution