Interested to Buy Any Domain ? << Click Here >> for more details...
Can you use a commit statement within a database trigger?
- 4 Answers
- 5278 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 |
When do I need to use a semicolon vs a slash in oracle sql?
What are Schema Objects ?
Is truncate autocommit in oracle?
two tables are there emp(eno,ename,sal,deptno),dept(deptno,dname).how form the query in deptno,ename,max(sal)
3. Adapt your query in (2) above so that only post codes with more than twenty orders are displayed.
What are the types of Database Links ?
How to start a specific oracle instance?
Why we choose emp number as primarykey?
What is Hash Cluster ?
Why does oracle 9i treat an empty string as null?
Can you drop an index associated with a unique or primary key constraint?
How to define an anonymous procedure with variables?
Oracle General 
