We can use savepoint. This transactional control statement can be used to

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

Question Posted / kalyan maddipati

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

How does a covering index work?

907

i have some prob lem to tell me about my self in interview first round ...

2116

What is ttitle and btitle?

1006

What does cursor do in sql?

971

how many groups of data types? : Sql dba

973

What are the different sql languages?

987

how can we find the number of rows in a table using mysql? : Sql dba

1031

How do I access sql anywhere database?

921

What is sqlite format?

1113

Which is better join or inner query?

962

How do you bind variables in pl sql?

1036

Is trigger a stored procedure?

887

What are procedures used for?

924

What is difference between pl and sql?

994

Do we need to create index on primary key?

858