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
Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun
What is a package in oracle?
How do I start tns listener?
How can I create database in oracle?
How to retrieve data from an explicit cursor?
What is a package ? What are the advantages of package ?
How do I limit the number of rows returned by an oracle query after ordering?
Does oracle partitioning improve performance?
Compare and contrast between sql and sql server and explain its various functions?
Is insert autocommit in oracle?
What is save point in oracle database?
How to delete multiple rows from a table in oracle?
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
How will you identify oracle database software release?
How to set a transaction to be read only in oracle?