Posted inORACLE

Row level, statement level Trigger

Create two tables based on the query: Copy CodeCopiedUse a different BrowserCREATE TABLE product ( MESSAGE VARCHAR2 (50), CURRENT_DATE DATE ); CREATE TABLE product_log ( MESSAGE VARCHAR2 (4000), CURRENT_DATE DATE…
February 24, 2020
Handle trigger Mutating Error
Posted inORACLE

Handle trigger Mutating Error

Many times we have faced the problem of trigger Mutating error. error ORA-04091: table TEST1.TEST_MUTATING is mutating, trigger/function may not see it let see how it comes and resolve Create…
April 25, 2017