Can you use a commit statement within a database trigger?
Answers were Sorted based on User's Feedback
Answer / charan
Hi this is charan...
Actually Not allowed TCL commands in trigger...but it is possible we are not use directly these commands...to over come this problem oracle introduced one concept is called "Autonomous Transactions" .through autonomous transaction we are using tcl commands in Trigger concept....This is according to my knowledge
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / karthik
yes, by autonomous transaction we can use commit.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / usingh
Yes, using AUTONOMOUS_TRANSACTION Pragma you can COMMIT and ROLLBACK.
Is This Answer Correct ? | 1 Yes | 1 No |
SELECT THE RECORDS FROM 3 TABLES LIKE(T1,T2,T3) AND HOW CAN WE INSERT THAT RECORD IN ANOTHER TABLE LIKE(T4)?
Anybody can tell me, how do we find second largest emp salary from emp table.. Thanks in advance ...
10 Answers Cognizant, ID, NTTF Nettur Technical Training Foundation, Sony, Verizon,
What is SAVE POINT ?
In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?
Which Database is the best for the Security issue ? 1. DB2 2.SQL Server 3.MySQL 4.ORACLE
What is key preserved table?
Is primary key indexed by default in oracle?
What is concurrency in oracle?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
What is the difference between RBBMS & DBMS?
I have table-A(1,2,3,4,4,5,6,6,6,7). how to get all duplicate values?what is sql query?
What are the components of Physical database structure of Oracle Database?