can you write commit in triggers?

Answer Posted / selvam.p

No, In normal condition, commit or rollback inside the
trigger is not possible.

Is This Answer Correct ?    5 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you get nicely formatted results from an oracle procedure that returns a reference cursor?

547


definition of cluster and non-clustered index?

2475


How to use group functions in the select clause using oracle?

591


How to use in conditions in oracle?

549


What is the quickest way to export a table to a flat file?

568






Give the constructs of a package, function or a procedure.

535


Explain mutating triggers.

569


How to run create database statement?

570


Explain the different normalization forms?

589


What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

1605


What is concurrency in oracle?

540


How to use an explicit cursor without open statements?

612


What is a procedure in oracle?

616


What is a select query statement in oracle?

543


Please explain joins in oracle?

547