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


Please Help Members By Posting Answers For Below Questions

what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba

551


What are operators available in sql?

585


how to convert numeric values to character strings? : Sql dba

566


How do I copy a table in sql?

515


What are predefined functions in sql?

531






Explain aggregate functions are available there in sql?

532


What are the types pl/sql code blocks?

609


What is a primary key example?

511


What happens when a trigger is associated to a view?

500


What are the types of operators available in sql?

552


How does join work in sql?

554


what are the types of subquery? : Sql dba

585


What's the difference between inner join and left join?

511


Where is sql database stored?

518


How do I write a cron which will run a sql query and mail the results to agroup?

524