Creation d'un trigger sql

 CREATE OR REPLACE TRIGGER trigg_example
 BEFORE INSERT OR UPDATE ON table_example
 FOR EACH ROW
 WHEN (new.no_line > 0)
 DECLARE
     evol_exemple number;
 BEGIN
     evol_exemple := :new.exemple  - :old.exemple;
     DBMS_OUTPUT.PUT_LINE('  evolution : ' || evol_exemple);
 END;

Source: sql.sh

Similar codes

1 vote150 views1 answer
Where to locate set password for mysql
SQL
4 votes244 views6 answers
Laravel jwt
SQL
11 votes142 views2 answers
Oracle source code
SQL
0 vote136 views1 answer
Postpresql relation not found
SQL
0 vote139 views1 answer
Get foreign table names mysql
SQL
0 vote172 views1 answer
Sql get latest of 2 datetimes
SQL
0 vote148 views1 answer
Plsql check for string in numeric
SQL
0 vote134 views1 answer
Sqlcmd xml output insert line break after every 2033 characters
SQL
0 vote186 views1 answer
The SELECT permission has not been granted on 'sys.sql_logins' for the 'master' database. You must be a member of the 'loginmanager' role to access this system view.
SQL
1 vote151 views1 answer
Oracle turn off constraint
SQL