Advertisement
Guest User

Untitled

a guest
Feb 27th, 2016
95
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE TABLE test(zdarzenie VARCHAR2(250));
  2. INSERT INTO Czytelnik VALUES (3,'Kowalski','Jan','Lodz');
  3. INSERT INTO Czytelnik VALUES (5,'Góra','Janina','Lodz');
  4. COMMIT;
  5.  
  6. CREATE OR REPLACE TRIGGER usun_czytelnik
  7. BEFORE DELETE ON Czytelnik
  8. BEGIN
  9. INSERT INTO test(zdarzenie) VALUES ('W dniu ' || TO_CHAR( SYSDATE, 'YYYY-MM-DD')|| ' skasowano wiersze');
  10. END;
  11. COMMIT;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement