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
8464 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

what is difference between po_headers_all and po_headers

5 Answers Deloitte, Wipro,

Are there any alternate tools other than sql* loader to load data into oracle apps tables from external systems

5 Answers Deloitte, IBM,

In xml report, how to print the headings in every page?

1 Answers Sierra Atlantica,

can we execute one concurrent program through another concurrent program?

1 Answers KPIT,

which parameters passed in report in oracle developer how to pass

1 Answers Wipro,

CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP

0 Answers IBM,

What are the different components of soa suite?

0 Answers

What is invoice?

3 Answers Murugappa Group,

please explain open interface import

2 Answers

hi all.i am in need of some sample codes for oracle apps manufacturing interfaces.If any of u have,plz send it to me . Thank you.

1 Answers BirlaSoft,

In which directory your flatfile is given?if u connected different instance where it is find?

3 Answers

what is tuning in oracle apps technical

3 Answers TCS,

For more Oracle Apps Technical Interview Questions Click Here