Interested to Buy Any Domain ? << Click Here >> for more details...
What is a mutating table
- 5 Answers
- 11218 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 a constraint. Types of constraints ?
5 Answers Accenture, BirlaSoft,
how can stop the sequence with mention the max value and with out mention the max value
What are the data types allowed in a table?
How do you delete duplicates in sql query using rowid?
Can we use two order by clause in query?
What is percent sign in sql?
how to concatenate two character strings? : Sql dba
what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql
What is difference between inner join and self join?
What is the syntax and use of the coalesce function?
what are Dynamic SQL statements?
How to get list of all tables from a database?
-
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)
