I am insert in data to a table X .Which one is better while writing commit sta

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.

Question Posted / dev

3 Answers
8422 Views
IBM, I also Faced
E-Mail Answers

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 lexical parameter?

3 Answers TCS,

name all status attributes.

1 Answers Scan Steel,

in one report using two layout models.if yes how to do

2 Answers

why do we validate the records while developing interface?

3 Answers TCS,

what is repeting frame?

3 Answers TCS,

What is workflow?Explain with a example?

2 Answers Oracle,

Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?

0 Answers

WHAT IS THE VIEW IN ORACLE APPS?HOW IS IT CREATED?

4 Answers

What is invoice?

3 Answers Murugappa Group,

what is inbound and outbound interface?

2 Answers

What is ERP? Architecture of apps?

3 Answers TCS,

For more Oracle Apps Technical Interview Questions Click Here