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

3 votes280 views2 answers
Pl sql escape '
SQL
0 vote288 views1 answer
Mssql view column data type
SQL
1 vote302 views1 answer
Oracle select row max date
SQL
0 vote297 views2 answers
Mysql decimal remove trailing zeros
SQL
1 vote270 views1 answer
Select statement to print longest name
SQL
3 votes294 views2 answers
Create schema postgres
SQL
9 votes313 views3 answers
Date format in sql
SQL
1 vote295 views2 answers
Postgresql remote connect
SQL
1 vote289 views1 answer
How to update date add hours in postgresql
SQL
2 votes289 views1 answer
Add default sql server
SQL