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

0 vote195 views1 answer
Oracle chain step succeeded
SQL
1 vote197 views1 answer
Postgres install unaccent extension
SQL
3 votes160 views1 answer
Search for column name in psql
SQL
0 vote207 views1 answer
Sql server delete records with specific date
SQL
0 vote195 views1 answer
How to user id to show in from date to upto date in mssql server
SQL
0 vote173 views1 answer
Postgresql heritage
SQL
1 vote223 views1 answer
Select not matching data with join table
SQL
0 vote184 views1 answer
Sqlite explain plan
SQL
1 vote203 views1 answer
Hackerrank sql test solutions
SQL
0 vote177 views2 answers
Python mysql create table if not exists
SQL