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
what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba
What are operators available in sql?
how to convert numeric values to character strings? : Sql dba
How do I copy a table in sql?
What are predefined functions in sql?
Explain aggregate functions are available there in sql?
What are the types pl/sql code blocks?
What is a primary key example?
What happens when a trigger is associated to a view?
What are the types of operators available in sql?
How does join work in sql?
what are the types of subquery? : Sql dba
What's the difference between inner join and left join?
Where is sql database stored?
How do I write a cron which will run a sql query and mail the results to agroup?