/SQL/Plsql trigger insert update

Plsql trigger insert update

Pl sql trigger update sysdate

CREATE OR REPLACE TRIGGER QUESTION_DATE BEFORE INSERT ON QUESTION 
FOR EACH ROW
BEGIN
 :NEW.CREATED_TIMESTAMP := SYSDATE;
END;

0

Source: stackoverflow.com

Similar codes

0 vote129 views1 answer
Having trouble running COUNT in my INSERT INTO statement
SQL
0 vote142 views1 answer
Postgresql replace html tags from string
SQL
0 vote128 views2 answers
Mysql to python pandas
SQL
0 vote122 views1 answer
Psql datestyle
SQL
10 votes81 views1 answer
Oracle view dependencies
SQL
1 vote133 views1 answer
Multiple count in sql
SQL
0 vote127 views1 answer
How to get n result in sql
SQL
0 vote127 views1 answer
Codeigniter 3 get best-selling products
SQL
7 votes227 views2 answers
Sql empty table
SQL
2 votes140 views1 answer
How to make multiple keys as primary in bdms
SQL

Share