Can you use a commit statement within a database trigger?
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
Explain about functional dependency and its relation with table design?
Can a formula column referred to columns in higher group ?
How to create a new oracle data file?
how to do daily transactions with out sql* loader control file regesterd in apps?
Explain the use of Merge statement in oracle 11g
What are the differences between date and timestamp in oracle?
What is the difference between a primary key & a unique key?
What is partitioned table in Oracle?
What is recovery manager(rman) backup in Oracle?
What is meant by an index?
What is transport network substrate (tns) in oracle?
In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??
Explain integrity constraints?
material view and view disadvantages?
Which environment variables are absolutely critical in order to run the OUI?