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 vote168 views1 answer
ELECT list is not in GROUP BY clause and contains nonaggregated column 'schogdsw_db.SE.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
4 votes231 views4 answers
Check constraint in ms sql
SQL
1 vote126 views1 answer
Postgres kill pid
SQL
11 votes177 views3 answers
Change column name sql server management studio
SQL
0 vote185 views1 answer
Allow null in psql
SQL
0 vote175 views1 answer
Oracle cpu metric
SQL
1 vote164 views1 answer
Sql delete all values in a column
SQL
1 vote205 views1 answer
Primary key with prefix sql
SQL
12 votes178 views1 answer
Docker run mysql image
SQL
0 vote169 views1 answer
Oracle flush Shared Pool
SQL