Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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.

Answers were Sorted based on User's Feedback



I am insert in data to a table X .Which one is better while writing commit statement After each r..

Answer / anu

after all row insert into table

Is This Answer Correct ?    5 Yes 1 No

I am insert in data to a table X .Which one is better while writing commit statement After each r..

Answer / swarna.alizerla

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

I am insert in data to a table X .Which one is better while writing commit statement After each r..

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

Post New Answer



More Oracle Apps Technical Interview Questions

How to develop XML report without rdf?

4 Answers   Oracle,


what is multi org structure?

3 Answers   Covansys, TCS,


what is instead of trigger. what is the use of that?

3 Answers  


How we print the multi language in report?can any one give me step bye step explanation.

2 Answers   HCL, IBM, Tech Mahindra,


How to know the number of invoices generated for one PO from front end (navigation)?

1 Answers   Oracle,






What do you understand by a set of books?

0 Answers  


Except the SRS window in which we can submit the concurrent program.

5 Answers   IBM, TCS,


explain o2c cycle? what are the table reflected for this process?

1 Answers   BirlaSoft,


how to change the logo in template dynamically?

2 Answers   Sierra Atlantica,


Please let me know the differance between Master Item and organization Item in Inventory.

5 Answers   Wipro,


what is the difference between oracle applications ebs 11.5.9 and 11.5.10.2 and can anyone suggest the release dates of the versions

1 Answers  


How many standard interface programs in oracle purchasing module and oracle inventory? What are they?

3 Answers   KPIT,






Categories
  • Oracle Apps Technical Interview Questions Oracle Apps Technical (547)
  • Oracle Apps Financial Interview Questions Oracle Apps Financial (791)
  • Oracle Apps Manufacturing Interview Questions Oracle Apps Manufacturing (53)
  • Oracle Apps HRMS Interview Questions Oracle Apps HRMS (169)
  • Oracle Apps CRM Interview Questions Oracle Apps CRM (9)
  • Oracle Apps SCM Interview Questions Oracle Apps SCM (141)
  • Oracle Install Base Interview Questions Oracle Install Base (62)
  • Oracle Service Contracts Interview Questions Oracle Service Contracts (101)
  • Oracle Apps AllOther Interview Questions Oracle Apps AllOther (114)