How to solve mutating table Error? Oracle PL\SQL

What is mutating table Error?

One of the scenario when mutating table errors occurs when Table A is parent to Table B and there are triggers defined on table A trigger a1 and on Table B trigger b1.
Triggers are defined in such way that before insert trigger a1 on A

Mutating table error
before insert trigger b1 on Table B. inside trigger b1 you are trying to check value in parent table if it exits parent field. While in parent Table A triggers are called before insert which having reference to Table B values. this leads to kind of race conditions causing mutating table error.
How to solve mutating table error?
While writing trigger care should be taken that parent table triggers should try to avoid update to child table otherwise mutating table error occur.
There are more scenario which would be covered in next Example you can just read many reference available on Mutating table Error.
just do a google search and read its common PL/SQL error which would face.

second option: Use after insert trigger.
More details: next

suggestion to Recent IT Graduate Students



1. Gain Practical Exposure 

Undergo atleast 1 project related to Network virtualisation, AJAX/Web services/Web programming with Web security and host them for your exposure ,others benefits..

Use technology like, AJAX , web services,Ws-security, project.

2. Experiment with cloud computing technology like Apache hadoop
3. try to do Embeded project it very Easy
Its actually old technology now :
4 RDBMS do Oracle SQL, PL/SQL or informix, db2 certification…
5. Network and learn latest technology not in course online….