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
Which is better cte or subquery?
What information is needed to connect sql*plus an oracle server?
What is error ora-12154: tns:could not resolve the connect identifier specified?
Does sql require a server?
What are the various levels of constraints?
How can I change database name in sql?
What is prepared statement in sql?
what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?
What is localdb mssqllocaldb?
What are the usages of sql?
What is case function?
What does the file extension accdb stand for?
define sql insert statement ? : Sql dba
What do you mean by “trigger” in sql?
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