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
8285 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 make a parameter optional in the query?

2 Answers Wipro,

In a Standard form a DFF is disable?How we can Enable it?

5 Answers Caritor, TCS,

what is tuning in oracle apps technical

3 Answers TCS,

What is the most critical part which you had faced in your project ?

1 Answers LG, Satyam, Tech Mahindra,

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

4 Answers

what is aim methodolozy

1 Answers

Form development process?

1 Answers

Could any one tell me the steps of conversions and what kind of validations and exceptions do we use during this conversion? Please do answer in detail. what program do we write in user exit in reports?

3 Answers iGate,

which API to return the parameters & valuesets etc

1 Answers GE, TCS,

why r u transer the data base tables to flat file and what is use

3 Answers Wipro,

What are the tables in GL?

3 Answers Convergys,

Registering parametric report?

1 Answers

For more Oracle Apps Technical Interview Questions Click Here