Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / sudhir
by default Trigger doesnt allow a commit;
however we can create a stored procedure which will only do
commit.
create or replace procedure to_commit_trigger
begin
commit();
end to_commit_trigger
now execute this stored procedure to_commit_trigger inside a
trigger to perform a commit. However it will cause serious
performance issues.
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
What is bulk copy or bcp in oracle?
How to declare a local variable?
How do I use os authentication with weblogic jdriver for oracle and connection pools?
How can we force the database to use the user specified rollback segment?
What is a trace file and how is it created in oracle?
What is key preserved table?
How to set a transaction to be read only in oracle?
How to use like conditions in oracle?
What happens to the data files if a tablespace is dropped?
What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar
Can multiple cursors being opened at the same time?
What do you mean by redo log file mirroring?
What is the difference between hot backup and cold backup in oracle?
How to view existing locks on the database?
Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.
