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 is assignment operator in pl sql?

764


When is the explicit cursor used ?

764


what is isam? : Sql dba

768


Why we use sql profiler?

722


What is the difference between a database and a relational database?

766






In what condition is it good to disable a trigger?

742


What is cursor in pl sql?

767


Write a query to display the current date in sql?

737


Is inner join faster than left join?

874


What are the advantages of sql?

777


What is an example of translating a date into julian format?

776


How do you drop a trigger?

711


How to move files from one directory to another in pl sql?

856


What is varchar sql?

814


What is meant by cursor in sql?

725