Advertisement
Guest User

Untitled

a guest
Jun 12th, 2018
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.53 KB | None | 0 0
  1. CREATE OR REPLACE TRIGGER LOG_KLIENCI_TRIGGER
  2.   AFTER INSERT OR UPDATE OR DELETE
  3.   ON KLIENCI
  4. DECLARE
  5.   log_action  LOGI.CZYNNOSC%TYPE;
  6. BEGIN
  7.   IF INSERTING THEN
  8.     log_action := 'Insert';
  9.   ELSIF UPDATING THEN
  10.     log_action := 'Update';
  11.   ELSIF DELETING THEN
  12.     log_action := 'Delete';
  13.   ELSE
  14.     DBMS_OUTPUT.PUT_LINE('This code is not reachable.');
  15.   END IF;
  16.  
  17.   INSERT INTO LOGI (NAZWA_TABELII, CZYNNOSC, DATA_ZMIANY)
  18.     VALUES ('KLIENCI', log_action, SYSDATE);
  19. END;
  20. /
  21. ALTER TRIGGER "LOG_KLIENCI_TRIGGER" ENABLE;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement