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

How can I make sql query run faster?

564


How do I create a sql database?

528


What is the difference between partitioning and sharding?

530


what is the difference between blob and text? : Sql dba

531


What is dml and ddl?

527






What is union and union all keyword in sql?

568


What is sql data?

558


Can a foreign key be a duplicate?

512


Where can I learn sql for free?

509


How many row comparison operators are used while working with a subquery?

543


What is the difference between microsoft access and sql server?

536


Name three sql operations that perform a sort.

594


Does sql profiler affect performance?

561


How insert into statements in sql?

595


What is the use of sql trace?

484