/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 vote221 views1 answer
Aqua Data studio postgresql ssl
SQL
16 votes129 views4 answers
Sort by sql
SQL
0 vote138 views1 answer
Contact mysql column field
SQL
5 votes135 views3 answers
How to remove unique key constraint in mysql
SQL
0 vote147 views1 answer
Mysql insert multiple rows based on select
SQL
6 votes135 views3 answers
How to delete table sqlite
SQL
2 votes143 views2 answers
Sql strip non alphanumeric characters
SQL
4 votes139 views1 answer
An error occurred while installing pg (1.2.3), and Bundler cannot continue. Make sure that `gem install pg -v '1.2.3' --source 'https://rubygems.org/'` succeeds before bundling.
SQL
0 vote138 views1 answer
Describe in sqlite3
SQL
3 votes131 views1 answer
Oracle revoke grant
SQL