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
How to estimate disk space needed for an export job?
What is literal?
What is difference between cartesian join and cross join?
Explain the use of record option in exp command.
How to call a stored function with parameters?
How to drop an existing table in oracle?
How to define a variable to match a table column data type?
How to connect to the server with user account: sys?
Who developed oracle & when?
What is Reduced List of Values?
How would you best determine why your MVIEW couldnt FAST REFRESH?
How to use select statement to count the number of rows in oracle?
What is a sub query and what are the different types of subqueries?
What is object data modeling?
How to do clean up if create database failed?