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
what's query optimization and without use of IN AND Exist can we get another way data from query
What is oracle datasource?
What are ddl statements in oracle?
Explain the use of constraints option in exp command.
What is a package ? What are the advantages of package ?
What is control file used for?
Explain oracle’s server parameter file.
How do you bind variables in oracle?
Explain mutating triggers.
What is pragma autonomous transaction in oracle?
How can you use check constraints for self referential integrity?
How to use "in out" parameter properly?
Can we call procedure inside function in oracle?
what is the use of system.effective.date variable in oracle?
Explain the features of oracle?