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 define a variable of a specific record type?
How to invoke the data pump export utility?
Explain enable novalidate constraint.
How to create a testing table in oracle?
How to create a new oracle data file?
List the various oracle database objects?
How to drop an index?
Does facebook use oracle?
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
21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.
How to use fetch statement in a loop?
How to work with data objects interactively?
How to connect asp pages to oracle servers?
What are the various types of snapshots ?
How do I know if oracle is installed on windows?