/SQL/Work around for mutating problem in Oracle Triggers. Please check it out.

Work around for mutating problem in Oracle Triggers. Please check it out.

CREATE OR REPLACE TRIGGER trg_check_salary_bs
BEFORE insert or update OF salary,manager_id   /* statement-level trigger */
ON employees  
BEGIN
     trg_check_pkg.init_data;
END;
/

Source: srikanthtechnologies.com

Similar codes

1 vote282 views1 answer
Connect to mysql database ubuntu
SQL
0 vote196 views1 answer
Change default schema sql server
SQL
1 vote211 views2 answers
Sql server concat string and int
SQL
0 vote250 views1 answer
Mysql date equals to current_date plus days
SQL
0 vote221 views1 answer
How to to get time in sql
SQL
1 vote215 views1 answer
Oracle create program if no exists
SQL
1 vote207 views1 answer
Alter add syntax
SQL
0 vote201 views2 answers
Postgresql get last day of month
SQL
0 vote221 views1 answer
How to change mysql port in xampp
SQL
0 vote280 views1 answer
Jooq replace
SQL