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 connect to a local oracle 10g xe server?
Give the advantages and disadvantages of clusters.
What are the differences between number and binary_float in oracle?
Query to retrieve record for a many to many relationship ?
How to start your 10g xe server?
What is meant by joins? List out the types of joins.
How do I spool to a csv formatted file using sqlplus?
How to invoke the data pump export utility?
How to export data to a csv file?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
Differentiate between function and procedure in oracle.
What do you mean by merge in oracle?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
How to upsert (update or insert into a table)?
What privilege is needed for a user to create tables in oracle?
