Can we use commit or rollback in trigger? If yes, then how. Please explain with a suitable example?
Answer Posted / nishi.swain@gmail.com
using pragma autonomous transaction
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
How many tables can you join in sql?
How many types of tables are there?
What is difference between pls_integer and integer?
Which one is better sql or oracle?
Does oracle roll back the transaction on an error?
How delete a row in sql?
What is the difference between sum and count in sql?
What is date functions?
How do I create an index in word?
What are keys in sql?
What is t sql used for?
What are sql objects?
- 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?
What is Difference Between Unique and Primary Key Constraints?
What is the purpose of cursors in pl/sql?