Commitment issues 1

[CIMTEET]

This is not a marital question. I am doing multiple updates in a database along with inserting records in a cursor for loop. I was thinking that maybe after i have done all the inserts and updates then I could commit once. Is that true or do I need to commit after every update?

 

[SantaMufasa]

CIMTEET,

One "COMMIT;" is sufficient at the end of the PL/SQL block.

And on the topic of marital issues...Did you hear about the the girl that broke up with her DBA boyfriend because he was two-phased and afraid to COMMIT?

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[CIMTEET]

I don't get the two phased part

 

[CIMTEET]

I don't get the two-phased part

 

[SantaMufasa]

CIMTEET,

For Distributed Databases, Oracle created a scheme called "Two-Phased COMMIT". My reference was totally an "Oracle Geek" joke. (Sorry I was oblique.)

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]