Home » SQL & PL/SQL » SQL & PL/SQL » UPDATE USING CURSOR FLAT FILE PROBLEM!
UPDATE USING CURSOR FLAT FILE PROBLEM! [message #243914] Mon, 11 June 2007 00:44 Go to next message
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 Go to previous message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
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

Previous Topic: NOT urgent. ORA-01555: snapshot too old: rollback segment number 1 with name "_SYSSMU1$"
Next Topic: Bulk Inserts using existing functions
Goto Forum:
  


Current Time: Sun Dec 11 04:30:14 CST 2016

Total time taken to generate the page: 0.05683 seconds