What do you want to save?
Add Code snippet
New code examples
-
SQL 2022-02-11 13:10:37
pl sql trigger determine if insert or update or delete
CREATE OR REPLACE TRIGGER Audit_emp AFTER INSERT OR UPDATE OR DELETE ON Emp_tab FOR EACH ROW DECLARE Time_now DATE; Terminal CHAR(10); BEGIN -- get current time, and the terminal of the user: Time_now := SYSDATE; ... Add solution -
SQL 2021-10-06 22:04:11
create trigger syntax
-- Oracle DB Syntax CREATE OR REPLACE TRIGGER {trigger_name} BEFORE | AFTER INSERT | UPDATE | DELETE ON {table_name} (FOR EACH ROW) {operation to be executed} -- for example CREATE TRIGGER log_updates AFTER INSERT OR UPDATE ON Person FOR EACH ROW I... Add solution -
PHP 2021-09-15 03:02:02
php adodb transaction
/* * Start transaction scope */ $conn->beginTrans(); /* * Execute some insert or update SQL */ $ok = $conn->execute($sql); if ($ok) { /* * The previous execution succeeded, do some more */ $ok = $conn->execute($sql2); }... Add solution