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

6 votes305 views1 answer
T-sql test if table exists
SQL
0 vote288 views1 answer
Sub blocks in sql
SQL
0 vote307 views1 answer
After kill process Failed to start mysqld.service: Unit mysqld.service not found.
SQL
0 vote290 views1 answer
Create a PostgreSQL user django on mac
SQL
3 votes305 views4 answers
Stop MySQL
SQL
1 vote290 views1 answer
Check message id sql server
SQL
0 vote382 views1 answer
SCRAM authentication requires libpq version 10 or above (SQL: select * from information_schema.tables where table_schema = public and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote353 views1 answer
Drop view sql
SQL
0 vote288 views2 answers
Change database postgres
SQL
0 vote375 views1 answer
Mysql get longest string in column
SQL