ALLInterview.com :: Home Page            
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
Do you have a collection of Interview Questions and interested to share with us!!
Please send that collection to along with your userid / name. ThanQ
Google
   
 
Categories  >>  Software  >>  Databases  >>  SQL PLSQL
 
 


  

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question 
how instead of triger is helpful for mutating tables errors 
handlling ?
 Question Submitted By :: Sudhir
I also faced this Question!!     Rank Answer Posted By  
 
  Re: how instead of triger is helpful for mutating tables errors handlling ?
Answer
# 1		 create a view (simple view) on mutating table

write a tigger on view (define similar to table)


Know try to do dml operations on table

it will not show the mutating error 
Is This Answer Correct ?    2 Yes 2 No
Mahesh
 
  Re: how instead of triger is helpful for mutating tables errors handlling ?
Answer
# 2		 "Mutating" means "changing". A mutating table is a table
that is currently being modified by an update, delete, or
insert
statement. When a trigger tries to reference a table that is
in state of flux (being changed), it is considered
"mutating" and
raises an error since Oracle should not return data that has
not yet reached its final state.
Another way this error can occur is if the trigger has
statements to change the primary, foreign or unique key
columns of the
table off which it fires. If you must have triggers on
tables that have referential constraints, the workaround is
to enforce the
referential integrity through triggers as well.
There are several restrictions in Oracle regarding triggers:
• A row-level trigger cannot query or modify a
mutating table. (Of course, NEW and OLD still can be
accessed by the
trigger) .
• A statement-level trigger cannot query or modify a
mutating table if the trigger is fired as the result of a
CASCADE delete.

So some time we can not use triggers to put DMl operations
on table. that time we can use INSTEAD OF TRIGGER. 
Is This Answer Correct ?    5 Yes 0 No
Guru
 
 
 

 
 
 
Other SQL PLSQL Interview Questions
 
  Question Asked @ Answers
 
how to get enames with comma seperated values by deptwise on emp table?  5
What is the difference between RDBMS and DBMS? Stag-Computers18
What is clustered and non-clustered indexes? Microsoft3
How One can easily select all even, odd, or Nth rows from a table using SQL queries?  3
Differentiate between %type and %rowtype attribute in Oracle PL/AQL programming ? PreVator6
function can return value ,procedure also return value through out parameter then what is the difference? 3i-Infotech3
How to execute OS(operating system) command from pl/sql?  3
Explain the usage of WHERE CURRENT OF clause in cursors ?  3
Whate is use of MOD function in pl/sql. Oracle3
I have a Employee table with columns ename,eid,salary,deptno. How to retrieve sum of salary for each deptno? L&T6
how to retrieve the top 2 salaried persons from a database? Orion-Laboratories6
Main diff between varray and nested tablea Polaris3
 
For more SQL PLSQL Interview Questions Click Here 
 
 
 
 
 


   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |   interview questions urls   External Links 
   
Copyright © 2012  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com