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


Please Help Members By Posting Answers For Below Questions

How to use attributes of the implicit cursor in oracle?

558


How to define a data source name (dsn) in odbc manager?

525


How to convert character types to numeric types?

572


Where do you use decode and case statements?

548


Does facebook use oracle?

571






How to count groups returned with the group by clause in oracle?

571


What view(s) do you use to associate a users SQLPLUS session with his o/s process?

1904


How to assign data of the deleted row to variables?

579


What are the attributes that are found in a cursor?

642


What is a cursor variable?

570


How can we create the complete backup of data in the oracle.

1682


How to retrieve data from an cursor to a record?

559


Can a parameter be passed to a cursor?

598


What is the recommended interval at which to run statspack snapshots, and why?

2430


What is a sub query? What are its various types?

582