sql trigger oracle update code example

Example: sql trigger oracle update

-- SQL Server (update my_table afeter update on my_table)
CREATE TRIGGER trTest ON my_table AFTER UPDATE AS
BEGIN
    UPDATE my_table SET my_col_date = getdate() FROM my_table 
END
-- Oracle (insert into log table after update on my_table)
CREATE OR REPLACE TRIGGER trTest AFTER UPDATE ON my_table
FOR EACH ROW
BEGIN
    INSERT INTO my_log_table (LOG_DATE, ACTION) VALUES (SYSDATE, 'Changed');
END;

Tags:

Misc Example

Related