Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE rules_log (
- id NUMBER GENERATED BY DEFAULT AS IDENTITY,
- city_name VARCHAR(255),
- description VARCHAR(100) NOT NULL,
- added_at TIMESTAMP(0) NOT NULL,
- CONSTRAINT rules_log_pkey PRIMARY KEY (id));
- CREATE OR REPLACE TRIGGER Flights.experiment2_t1
- AFTER INSERT ON Flights.timezones_ref
- FOR EACH ROW
- BEGIN
- INSERT INTO rules_log (city_name,description,added_at)
- VALUES (:NEW.city,'Trigger 3',SYSTIMESTAMP);
- END;
- /
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement