What is the best strategy to use COMMIT in a pl/sql loop?

Question Posted / guest

3 Answers
10176 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What is the best strategy to use COMMIT in a pl/sql loop?..

Answer / sudhakar naraparaju

It depends on the number of records being looped. If it is
a huge table then it is better to commit after a specific
number of transactions are completed. Even better to do
inside the loop so that the data is commited for every set
looped.

Is This Answer Correct ?

11 Yes

0 No

What is the best strategy to use COMMIT in a pl/sql loop?..

Answer / anil_abbireddy

End of the Block

Is This Answer Correct ?

3 Yes

2 No

What is the best strategy to use COMMIT in a pl/sql loop?..

Answer / kalyan maddipati

We can use savepoint. This transactional control statement
can be used to save records at perodic intervals

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More SQL PLSQL Interview Questions

which will fire first ? Trigger or Constraint

24 Answers i2, IBM,

What are local and global variables and their differences?

0 Answers

Is sql procedural language?

0 Answers

What are the two different parts of the pl/sql packages?

0 Answers

hi..........i m Accenture employee...Accenture is an IT company having itz branches in India at Mumbai, Pune,Delhi, Hyderabad, Chennai and Bangalore....Presently there are openings here for SAP, Testing, Oracle,Java,.NET,MAinframe and Peoplesoft...... I am a software engineer working with Accenture,Mumbai....u can mail me in your resume..i`ll forward it to our HR team...my mail id: pankit.lodaya@accenture.com

8 Answers Wipro,

What is sql and explain its components?

0 Answers

What is the difference between microsoft sql and mysql?

0 Answers

i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5

1 Answers

package specification-3 procedures package body-4 procedures how can i write for other procedure in package body

2 Answers Reliance,

define primary key & secondary key?

2 Answers

Why do we use joins?

0 Answers

what is 'force view'?

3 Answers Cap Gemini, SPIC,

For more SQL PLSQL Interview Questions Click Here