Interested to Buy Any Domain ? << Click Here >> for more details...
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
I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.
How do I limit the number of rows returned by an oracle query after ordering?
what is the difference between substr and instr function in oracle?
Is primary key indexed by default in oracle?
What are the different types of trigger and explain its various uses and functions?
Explain what does a control file contain?
What is oracle used for?
How to loop through data rows in the implicit cursor?
How to assign data of the deleted row to variables?
can u send the sql dumps to sivakumarr1987@gmail.com plz help me
What is object data modeling?
Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.
Why does Oracle not permit the use of PCTUSED with indexes?
How do we display rows from the table without duplicates?
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
