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 vote183 views1 answer
Grant privileges mysql to database 1064
SQL
21 votes198 views1 answer
SQL cheat sheet pdf
SQL
0 vote178 views1 answer
Sqlplus change user
SQL
0 vote206 views1 answer
Show specific events on mysql
SQL
3 votes192 views1 answer
Oracle drop user
SQL
0 vote193 views1 answer
Create table in mysql mariadb primary key foreign key
SQL
1 vote194 views1 answer
Sqlalchemy order by descending
SQL
0 vote172 views2 answers
Which MySQL statement is used to delete data from a database
SQL
0 vote187 views1 answer
Get schema of table sql
SQL
0 vote172 views1 answer
Sql transact create cursor with dynamic tables
SQL