Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE OR REPLACE TRIGGER LOG_KLIENCI_TRIGGER
- AFTER INSERT OR UPDATE OR DELETE
- ON KLIENCI
- DECLARE
- log_action LOGI.CZYNNOSC%TYPE;
- BEGIN
- IF INSERTING THEN
- log_action := 'Insert';
- ELSIF UPDATING THEN
- log_action := 'Update';
- ELSIF DELETING THEN
- log_action := 'Delete';
- ELSE
- DBMS_OUTPUT.PUT_LINE('This code is not reachable.');
- END IF;
- INSERT INTO LOGI (NAZWA_TABELII, CZYNNOSC, DATA_ZMIANY)
- VALUES ('KLIENCI', log_action, SYSDATE);
- END;
- /
- ALTER TRIGGER "LOG_KLIENCI_TRIGGER" ENABLE;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement