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

How to estimate disk space needed for an export job?

771


What is literal?

773


What is difference between cartesian join and cross join?

814


Explain the use of record option in exp command.

762


How to call a stored function with parameters?

760


How to drop an existing table in oracle?

816


How to define a variable to match a table column data type?

773


How to connect to the server with user account: sys?

790


Who developed oracle & when?

754


What is Reduced List of Values?

1900


How would you best determine why your MVIEW couldnt FAST REFRESH?

1635


How to use select statement to count the number of rows in oracle?

772


What is a sub query and what are the different types of subqueries?

879


What is object data modeling?

714


How to do clean up if create database failed?

791