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
Explain the use of log option in exp command.
how can we store any pdf file in oracle
How to use subqueries with the in operator using oracle?
is there a tool to trace queries, like profiler for sql server?
What is snapshot is too old? Give and example for better understand.
Explain what does a control file contain?
hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.
what is the difference between restoring and recovering?
How to use "in" parameter properly?
22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100
How to use "if" statements on multiple conditions?
How to use "while" statements in oracle?
How a database is related to tablespaces?
How to retrieve data from an explicit cursor?
What privilege is needed for a user to query tables in another schema?
