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 vote140 views1 answer
Get url of cpanel database hostname
SQL
4 votes217 views2 answers
Could not find driver (SQL: SHOW FULL TABLES WHERE table_type = 'BASE TABLE')
SQL
0 vote196 views1 answer
How to use mysql_tzinfo_to_sql on windows
SQL
0 vote158 views1 answer
Sql delete dastabase
SQL
3 votes167 views1 answer
Where id is in list sql
SQL
8 votes167 views1 answer
Oracle add datafile to tablespace
SQL
1 vote161 views1 answer
Mysql select and count left join
SQL
0 vote146 views2 answers
Select columns from 2 tables with foreign key
SQL
0 vote157 views1 answer
Create a sql server database programmatically
SQL
0 vote143 views1 answer
Sql datediff db2
SQL