Re: Oracle mass update script request.

by grinder (Bishop)

on Jul 28, 2008 at 10:21 UTC ( #700495=note: print w/replies, xml )

Need Help??

Why do you want to make life so miserable for yourself? Why not ask the database to do the update for you in one hit.

update table1 t1
set t1.field1 = 999
where exists (
    select 1 from table2 t2 where t1.id = t2.id
)
[download]

Then you just have to debug your SQL. No Perl needed apart from a $db->do(''), no bugs to look for! Not to mention faster...

• another intruder with the mooring in the heart of the Perl

Comment on Re: Oracle mass update script request. Download Code

Replies are listed 'Best First'.
Re^2: Oracle mass update script request. by dbmathis (Scribe) on Jul 28, 2008 at 12:08 UTC
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.	[reply]
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]

Domain Nodelet^?

Node Status^?

node history
Node Type: note [id://700495]
help

Chatterbox^?

How do I use this? | Other CB clients

Other Users^?

Others browsing the Monastery: (2)

As of 2023-05-28 02:37 GMT

Sections^?

Information^?

Find Nodes^?

Leftovers^?

Voting Booth^?

No recent polls found

Notices^?