Interested to Buy Any Domain ? << Click Here >> for more details...
Can you use a commit statement within a database trigger?
- 4 Answers
- 5464 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 |
What are ddl statements in oracle?
How to define and use table alias names in oracle?
I know that i can create a table without a primary key.But is there any significance for that table???? while creating an application.
What are the composite date types in oracle?
What is dual table oracle?
What is the data pump import utility?
Which environment variables are absolutely critical in order to run the OUI?
What are the execution control statements?
WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?
what is the difference between data migration and production migration.
What do you mean by merge in oracle?
Q) How to Find Max Date from each Group? (Asked in Infosys (INFI)Interview)
Oracle General 
