Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE test(zdarzenie VARCHAR2(250));
- INSERT INTO Czytelnik VALUES (3,'Kowalski','Jan','Lodz');
- INSERT INTO Czytelnik VALUES (5,'Góra','Janina','Lodz');
- COMMIT;
- CREATE OR REPLACE TRIGGER usun_czytelnik
- BEFORE DELETE ON Czytelnik
- BEGIN
- INSERT INTO test(zdarzenie) VALUES ('W dniu ' || TO_CHAR( SYSDATE, 'YYYY-MM-DD')|| ' skasowano wiersze');
- END;
- COMMIT;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement