Interested to Buy Any Domain ? << Click Here >> for more details...
Can you use a commit statement within a database trigger?
- 4 Answers
- 5610 Views
- I also Faced
- E-Mail Answers
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 |
how can we write trigger in trigger???????? can we write one trigger on two table???
What is the difference between SQL, DDL, and DML?
7 Answers BeBo Technologies, Wipro,
how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....
What is a Tablespace?
How index is implemented in oracle database?
What is primefaces used for?
Which of the following is not a database object TABLESPACE TABLE INDEX NONE
What is program global area (pga) in oracle?
How would you begin to troubleshoot an ORA-3113 error?
How to filter out duplications in the returning rows using oracle?
Tell me New Feature of Oracle 10g?
what is difference between where clause and having clause?
Oracle General 
