UPDATE USING CURSOR FLAT FILE PROBLEM! [message #243914] |
Mon, 11 June 2007 00:44  |
oracle_dev
Messages: 24 Registered: April 2007
|
Junior Member |
|
|
For updating i have used cursor.
I want to write it into lst the updated fields.
It updates fields in another table based on cursor.fieldvalue = table.fieldvalue in the where condition which is processed using the loop.
HERE I AM WRITING IN A FLAT FILE THEN AND THERE INSIDE THE LOOP. IT IS WRITING ALL THE ROWS POPULATED IN THE CURSOR.
BUT I WANT TO WRITE ONLY VALUES UPDATED THEN AND THERE IN THE FILE. IS THERE ANY METHOD LIKE ISROWUPDATED=TRUE LIKE, SO THAT BASED ON TRUE CONDITION I SHALL WRITE ONLY THOSE VALUES IN FLAT FILE INSTEAD ALL.
|
|
|
Re: UPDATE USING CURSOR FLAT FILE PROBLEM! [message #243931 is a reply to message #243914] |
Mon, 11 June 2007 01:21  |
 |
Michel Cadot
Messages: 68737 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
Quote: | For updating i have used cursor.
|
Is this necessary?
Please always post your Oracle version (4 decimals).
INSTEAD OF POSTING BLABLA IN CAPITALS POST AN EXAMPLE AND KEEP YOUR FINGER OFF THE SHIFT key. Post your final objective not the way you achieve it, maybe it is not the best one.
Regards
Michel
|
|
|