Can you use a commit statement within a database trigger?
Answer Posted / karthik
yes, by autonomous transaction we can use commit.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain the use of analyse option in exp command.
Differentiate between pre-select and pre-query?
Explain an index?
What are the oracle differences between nvl and coalesce
why should i declare foreign key constraint as self relation instead of binary relation in tables ?
how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?
Can you drop an index associated with a unique or primary key constraint?
What is key preserved table?
Can a formula column be obtained through a select statement ?
What is open database communication (odbc) in oracle?
How do you get nicely formatted results from an oracle procedure that returns a reference cursor?
How to delete a user account in oracle?
What is pragma autonomous transaction in oracle?
What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar
What is a relational database management system?