Interested to Buy Any Domain ? << Click Here >> for more details...
Can you use a commit statement within a database trigger?
- 4 Answers
- 5609 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 to assign values to data fields in record variables?
what is host string in sql plus? how does it related to database?
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
What are the predefined tablespaces in a database?
WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?
What is an Index ? How it is implemented in Oracle Database ?
What are the extensions used by oracle reports?
I need to get the values of the previous quarter.how to do this?eg: if my cuurent month is may i need to get the datas of the month jan,feb,march.Can it be done in oracle.I tried with date function q but for the month jan its not retriving the previous quarter(oct-dec).how to solve this.plpz anyone help me?
How to pass a parameter to a cursor in oracle?
How to join two tables in a single query using oracle?
Explain user account with reference to oracle.
difference between imlicit cursor and explicit cursor ?
Oracle General 
