Interested to Buy Any Domain ? << Click Here >> for more details...
Can you use a commit statement within a database trigger?
- 4 Answers
- 5405 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 recovery manager in Oracle?
which statement is running fastly ie insert or delete?
Please explain oracle left join with an example?
write a sql query following source looking like below column1 column2 101,102,103 abc,def,ghi 1001,1002,1003 a,b,c i want the output column1 column1 101 abc 102 def 103 ghi 1001 a 1002 b 1003 c
How do I connect to oracle?
what is difference between foreign key and reference key
how to find out second largest value in the table
Explain about the analyze command in oracle?
What is the simplest tool to run commands on oracle servers?
What is an oracle and why it is used?
I have query like this. select dept_id, max_mark from stude_dept where min_mark= (select min(mini_mark) from stud_dept); How can i optimize this query. Can anyone help me with it
what is the difference between joins and set operators.i am always confusing with two,can u pls kindly help me .
Oracle General 
