Interested to Buy Any Domain ? << Click Here >> for more details...
Can you use a commit statement within a database trigger?
- 4 Answers
- 5599 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How to run create database statement?
What is tns entry?
In what script is snap$ created? In what script is the scott/tiger schema created?
What is the difference between $oracle_base and $oracle_home?
What is data file?
What is blob data type in oracle?
What privilege is needed for a user to insert rows to tables in another schema?
How to add another datafile to a tablespace?
Explain mutating triggers.
What is format trigger?
How to concatenate two text values in oracle?
What is SQL Tuning Advisor in Oracle?
What is the purpose of save points in oracle database?
Will you be able to store pictures in the database?
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
