/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

3 votes308 views1 answer
Start mysql server by terminal in linux
SQL
13 votes308 views2 answers
Sql join 3 tables
SQL
5 votes296 views4 answers
Select random rows sql
SQL
0 vote292 views2 answers
How to find sql server agent jobs related to a database
SQL
0 vote287 views1 answer
How to set all the time serveroutput on in oracle sql developer
SQL
0 vote306 views1 answer
How to login to mysql in homestead
SQL
22 votes327 views3 answers
How to join three tables in sql using joins
SQL
0 vote251 views1 answer
How to set field to null in sql
SQL
2 votes323 views1 answer
Get the mysql table columns data type mysql
SQL
0 vote297 views1 answer
Mysql join only one column
SQL