Interested to Buy Any Domain ? << Click Here >> for more details...
I am insert in data to a table X .Which one is better while
writing commit statement
After each row inset or after all row insert to table.
- 3 Answers
- 8452 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
I think its better to use the savepoint when ever u want to
save till the specific insert.
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / kiddu
the best way is committing after all rows inserted but suppose we are using a proc that is inserting huge data suppose 4k or 5k records then its better to commit in every 1000 records to avoid "Snapshot too old error".
| Is This Answer Correct ? | 0 Yes | 0 No |
In Oracle Apps Some tables ends with TL,VL,what is the significance of the TL and VL?
while registering executable and concurent program we register both with application name|<oracle purchasing>? so my question is why we are defining in both concurent program and executable?
How do u customize the Reports?
Hi Friends this is preetham, i am searching for job on oracle apps(technical) i put 3 years fake exp, so any one please could you help me for realtime interview questions and 9739782164 this is my no srpsrp777@gmail.Com please guys please provide your no for contact i have a doubts i want to clarify
WHAT IS THE USE OF SKIP WHERE U WILL GIVE?
What are the Major differences between appcore.pll and appcore2.pll
5 Answers Infosys, Sierra Atlantica,
what is instead of trigger. what is the use of that?
Is it possible to do purchase order without requisition?
In a package have predefined exception and user defined exception. while execution which exception will be executed first? why?
In hierarchical structure of a database? we have write query from where we should start?
What is oracle soa suite?
can we use anchor propery in XML reports?if yes?explain?
Oracle Apps Technical 
