Interested to Buy Any Domain ? << Click Here >> for more details...
Can you use a commit statement within a database trigger?
- 4 Answers
- 5305 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 is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
I have table-A(1,2,3)& table-B(3,4,5).what is the different b/w below questions? A union all B? B union all A?
What are inner join and outer join?
How to write a query with a full outer join in oracle?
Will the Optimizer always use COST-based approach if OPTIMIZER_MODE is set to "Cost"?
How would you begin to troubleshoot an ORA-3113 error?
How to add another datafile to a tablespace?
Whether Oracle satisfy more codd rules or db2 satisfy more codd rules? How meny of each can satisfy ? Please answer me. Advance thanks
How to define a variable of a specific record type?
i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)
What is the difference between substr and instr?
What are the Characteristics of Data Files ?
Oracle General 
