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 vote157 views1 answer
Oracle procedure chain step
SQL
1 vote107 views1 answer
Postgres reset auto increment
SQL
0 vote180 views1 answer
.sql File Run in PSQL
SQL
1 vote165 views1 answer
Sql server: query to find out all the places where the table is used
SQL
-1 vote217 views1 answer
Pl sql drop trigger
SQL
0 vote159 views1 answer
Query to generate query to drop primary keys or foreign key in ms sql server
SQL
0 vote189 views1 answer
Compare strings lexicographically in sql
SQL
1 vote142 views1 answer
How refresh navicat tables to see new tables
SQL
0 vote157 views1 answer
SQL Server modify_timestamp trigger
SQL
-1 vote156 views1 answer
Condition in orderby mysql
SQL