Can you use a commit statement within a database trigger?
- 4 Answers
- 4250 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 difference between rollback & commit? can a foreign key has null value?
dear sir/madam, i have done my engg in 2007 after that i did oracle course (sql,plsql,forms,reports) .from 2008 to 2009 i searched job but didnt got.so i planned to move to sales field & i gone to dubai.till now i m in sales only.now i want to shift my career in to IT industry.but now people are not hiring as fresher.so i planned put fake 1 + exp. is it good or bad or any other way is there to enter in IT.please suggest me or call me 09632087338.
How to drop a tablespace?
What is concurrency in oracle?
How to load data from external tables to regular tables?
How to create id with auto_increment on oracle?
What are the parameters that we can pass through a stored procedure?
What is the difference between SQL, DDL, and DML?
7 Answers BeBo Technologies, Wipro,
which clause we are not used in where clause?
What do you mean by a tablespace?
What is background process in Oracle?
What is oracle open database communication (odbc)?
Oracle General 
