Can i use Commit inside the Trigger? Suppose i use commit
what will be happy (it's complied /executed/work)
Answer Posted / suresh babu
You cannot use the commit inside the trigger,because the
Transaction Control Languages(TCL) are not allowed in trigger.
Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
How do you optimize a query?
How can we find duplicate records in a table?
How do you break a loop in pl 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
What are the different datatypes available in PL/SQL?
what are the types of join and explain each? : Sql dba
how can we know the number of days between two given dates using mysql? : Sql dba
Define join and name different types of joins?
What are different joins used in sql?
Explain the difference between rename and alias?
How does index help in query performance?
How can we optimize a sql query?
What are all the common sql functions?
How do I remove sql plus from windows 10?
how to present a past time in hours, minutes and seconds? : Sql dba