Answer Posted / 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 |
Post New Answer View All Answers
What problem one might face while writing log information to a data-base table in pl/sql?
- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?
How to write pl sql program in mysql command prompt?
What are system versioned tables?
What is sap sql anywhere?
What is delimiter sql?
What is difference between sql and mysql?
What is sql profiler in oracle?
Define union, minus, union all, intersect ?
what is bdb (berkeleydb)? : Sql dba
Can we group by two columns in sql?
What is asqueryable?
How do I truncate a sql log file?
Are null values same as that of zero or a blank space?
Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?