Row level, statement level Trigger

Create two tables based on the query: insert into product values ('ashish',sysdate); / update product set message = 'Ashish Sahay' where current_date = sysdate; / Read more

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 TABLE test_mutating ( id NUMBER, name VARCHAR2(400 byte) ); INSERT... Read more