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
How to get execution path reports on query statements?
What is recovery manager(rman) backup in Oracle?
How view is different from a table?
State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.
6. Display the client name and order date for all orders using the traditional method.
What is instant client oracle?
How to pass parameters to procedures?
What is the exact use of Collections?
What is a directory object?
What is Undo Management Advisor in Oracle?
Where are the settings stored for each instance in oracle?
How to retrieve data from an explicit cursor?
How to commit the current transaction in oracle?
20. Using a set operator, display the client number of all clients who have never placed an order.
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
