Into a row-level trigger based on a table trigger body cannot read data from the same table and also we cannot perform DML operation on the same table.
<> If we are trying this oracle server returns mutating error oracle-4091: table is mutating.
<> This error is called mutating error, and this trigger is called a mutating trigger, and the table is called a mutating table.
<> Mutating errors are not occurred in statement-level trigger because through this statement-level trigger when we are performing DML operations automatically data committed into the database, whereas in the row-level trigger when we are performing transaction data is not committed and also again we are reading this data from the same table then only mutating errors occur.
Posted Date:- 2021-10-05 05:37:29
What Is Server Virtualization?
What Are The Computing Components Of Oracle Grid?
What Is The Difference Between Large Dedicated Server And Oracle Grid?
Explain Oracle Grid Architecture?
How can you improve the performance of Sql*loader?
What are the main aspects of oracle database security management?
What is a difference between ON DELETE CASCADE and ON DELETE SET NULL?
Which tools can you use to start up an Oracle database?
What do you mean by recovery catalog?
What is a nested table and how is it different from a normal table?
What is a trace file and how is it created in oracle?
Explain Oracle Grid Architecture?
What are the packages in PL SQL?
In what scenario you can modify a column in a table?
Explain the procedure of restoring RMAN for the recovery if all the instances are down.
What is a DEFAULT option in a table?
What are the dynamic performance views? Who has the access to these views?
Why is performance tuning a menacing area for DBA's?
Explain all Joins used in Oracle 9i and later release?
Explain all Joins used in Oracle 8i?
How do you find the total database size in the database?
What are the benefits of ORDBMS?
Can we save images in a database and if yes, how?
What are Constraints and how can we use them?
In what ways can you write comments in Oracle?
What do you mean by a database transaction & what all TCL statements are available in Oracle?
Explain primary key and unique key in Oracle?
What is the logical structure of the disk resources?
Why do we need integrity constraints in a database?
What are the differences between EBU and RMAN?
Name the various Oracle database objects?
Is there a difference between Alias and Rename?
What are Privileges and what is their purpose?
What are Errors and how do you deal with them?
Find the error in the below code snippet if any?
What are SQL functions? Describe in brief different types of SQL functions?