Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE OR REPLACE TRIGGER Beszuras AFTER INSERT ON Vasarlo FOR EACH ROW
- BEGIN
- INSERT INTO naplo VALUES(SYSDATE, 'Beszúrás az Vasarlo táblába', :NEW.vid || ', ' || :NEW.nev || ', ' || :NEW.asztal || ', ' || :NEW.nemzet );
- END;
- CREATE OR REPLACE TRIGGER Torles AFTER DELETE ON Vasarlo FOR EACH ROW
- BEGIN
- INSERT INTO naplo VALUES(SYSDATE, 'Törlés a Vasarlo kapcsolótáblából', :OLD.vid || ', ' || :OLD.nev || ', ' || :OLD.asztal || ', ' || :OLD.nemzet );
- END;
- CREATE OR REPLACE TRIGGER modositas AFTER UPDATE OF nev ON Vasarlo FOR EACH ROW
- BEGIN
- INSERT INTO naplo VALUES(SYSDATE, 'Név változtatás az Vasarlo táblában', :NEW.vid || ': ' || :OLD.nev || ' -> ' || :NEW.nev);
- END"
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement