Interested to Buy Any Domain ? << Click Here >> for more details...
Can you use a commit statement within a database trigger?
- 4 Answers
- 5473 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 define a data field as not null?
What is a static data dictionary in oracle?
How a database is related to tablespaces?
How to view the tablespaces in the current database?
What is the difference between 10g OEM and 11g OEM?
How can I create database in oracle?
What is hot backup and logical backup?
Why do you use stored procedures and state some of its disadvantages?
If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...
How to use subqueries with the exists operator in oracle?
How to synchronize 2 schema's objects?
A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.
What happens if variable names collide with table/column names?
What is connection pooling in oracle?
What are internal user account in oracle?
