Re^2: Oracle mass update script request.

in reply to Re: Oracle mass update script request.
in thread Oracle mass update script request.

grinder,

I must be missing something. Are you saying I can update 45000 records all at once? Were does the sql get the 45000 records from when they only exist in a flat text file?

I agree that the easiest solution is always the best solution. Can you please elaborate?

Best Regards

After all this is over, all that will really have mattered is how we treated each other.

Comment on Re^2: Oracle mass update script request.

Replies are listed 'Best First'.
Re^3: Oracle mass update script request. by roboticus (Chancellor) on Jul 28, 2008 at 12:16 UTC
dbmathis: Bulk load the flat file into a work table, then do your SQL. ...roboticus	[reply]
Re^4: Oracle mass update script request. by dbmathis (Scribe) on Jul 28, 2008 at 14:08 UTC
Makes sense. Thanks. After all this is over, all that will really have mattered is how we treated each other.	[reply]

In Section Seekers of Perl Wisdom