Interested to Buy Any Domain ? << Click Here >> for more details...
What is a mutating table
- 5 Answers
- 11119 Views
- TCS, Tech Mahindra, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / vishwa
Mutating means that some one is trying to access the table
currently being held by some other non-committing
transaction
| Is This Answer Correct ? | 9 Yes | 0 No |
Answer / saraswathi muthuraman
IF you have a trigger on table emp_test. Inside that
trigger, your are trying to update/insert in the same table
emp_test.
Then mutating table error will occur.
| Is This Answer Correct ? | 8 Yes | 0 No |
Answer / vijayakumar n
Trigger one executed again & again in a table.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / udaykumar
specified set of records we can commit or commit or
rollback regardless of parent transactions.
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / swastik
*When Ever You Create a Trigger On a Table And Performing Any DML Operation in Side The Trigger Body On Same Table Then Mutating Error Will Come.
*Row Level Trigger It Will Happen
| Is This Answer Correct ? | 0 Yes | 1 No |
What is basic structure of pl sql?
How do you explain an index number?
what are the performance and scalability characteristics of mysql? : Sql dba
What is set serveroutput on in pl sql?
Show how functions and procedures are called in a pl/sql block.
How to display all Friday's in a year with date?
What is a transaction?
What are different types of functions in sql?
Suppose I have to create a view on a table, that is not yet been created by DBA. I khow the table structure. Is it possible to create the view before DBA creates this table? If yes then how? Is it possible to create synonym in this way?
What is package in pl sql with an examples?
What is the trigger in sql?
explain the difference between myisam static and myisam dynamic. : Sql dba
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
