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


Please Help Members By Posting Answers For Below Questions

what's query optimization and without use of IN AND Exist can we get another way data from query

1922


What is oracle datasource?

777


What are ddl statements in oracle?

807


Explain the use of constraints option in exp command.

808


What is a package ? What are the advantages of package ?

862


What is control file used for?

831


Explain oracle’s server parameter file.

783


How do you bind variables in oracle?

768


Explain mutating triggers.

807


What is pragma autonomous transaction in oracle?

797


How can you use check constraints for self referential integrity?

759


How to use "in out" parameter properly?

826


Can we call procedure inside function in oracle?

824


what is the use of system.effective.date variable in oracle?

894


Explain the features of oracle?

827