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 vote145 views1 answer
Mariadb.service: main process exited, code=exited, status=1/failure
SQL
3 votes124 views1 answer
Two selects in one query
SQL
0 vote153 views1 answer
Ceil upto 2 decimal place mysql
SQL
0 vote135 views1 answer
Load data from text file to mysql database on mac terminal
SQL
0 vote149 views1 answer
How to do a function to return row type from a table in pl/sql
SQL
40 votes202 views4 answers
PostgreSQL add column
SQL
0 vote129 views1 answer
To change the database owner in SQL server
SQL
-2 votes121 views1 answer
How to open database
SQL
0 vote144 views1 answer
Remove transient options sql wordpress
SQL
0 vote135 views1 answer
Grant privileges mysql to database 1064
SQL