Is it possible to use Transaction control Statements such a
ROLLBACK or COMMIT in Database Trigger ? Why ?

Answer Posted / chintu

It is not possible. but if we want to put we use autonomous
transaction.

Is This Answer Correct ?    13 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which is better cte or subquery?

716


What information is needed to connect sql*plus an oracle server?

768


What is error ora-12154: tns:could not resolve the connect identifier specified?

826


Does sql require a server?

714


What are the various levels of constraints?

856






How can I change database name in sql?

709


What is prepared statement in sql?

750


what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?

2191


What is localdb mssqllocaldb?

805


What are the usages of sql?

752


What is case function?

780


What does the file extension accdb stand for?

711


define sql insert statement ? : Sql dba

750


What do you mean by “trigger” in sql?

801


i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5

3603