Advertisement
Guest User

Untitled

a guest
Apr 5th, 2020
161
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.46 KB | None | 0 0
  1. CREATE TABLE rules_log (
  2.     id NUMBER GENERATED BY DEFAULT AS IDENTITY,
  3.     city_name VARCHAR(255),
  4.     description VARCHAR(100) NOT NULL,
  5.     added_at TIMESTAMP(0) NOT NULL,
  6.     CONSTRAINT rules_log_pkey PRIMARY KEY (id));
  7.  
  8. CREATE OR REPLACE TRIGGER Flights.experiment2_t1
  9.     AFTER INSERT ON Flights.timezones_ref
  10.     FOR EACH ROW
  11. BEGIN
  12.     INSERT INTO rules_log (city_name,description,added_at)
  13.         VALUES (:NEW.city,'Trigger 3',SYSTIMESTAMP);
  14. END;
  15. /
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement