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
- 8291 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 |
CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP
WHAT IS THE VIEW IN ORACLE APPS?HOW IS IT CREATED?
Are you familiar with internet architecture of oracle apps 11i?
pls send me out bound code of supplers,site,bankiformation code pls as soon as
what is the database size you used?
Is soa a part of oracle fusion middleware?
mention the interface tables for item open interface and open transaction interface and also their respective production tables.
How will U link GL with OU in Multi-org environment.
What is a flexfield? List out its types.
WHAT IS USE OF APPS API?
which API to return the parameters & valuesets etc
What is count(*) from po_vendors(any table)?
Oracle Apps Technical 
