any updates on update opp.?

[robertbalmer]

I'm updating two columns in a table with two existing columns in the table....reason:I have to switch the TYPE from varchar2 to number

The count on the rows is approc. 160 000. I started the update almost 2hours ago and it is still running. Is there a better/faster procedure to do mass updates on rows.

I'm using plsql developer...update t1 set col1=col2;

[abhaysk]

Use Merge

[robertbalmer]

ALTER TRIGGER "my_triggername_ontable_insert/update/delete" disable; before the UPDATE.

Time saved=priceless.

Thanks for the tip on merge.

[slimdave]

Originally posted by robertbalmer
I'm updating two columns in a table with two existing columns in the table....reason:I have to switch the TYPE from varchar2 to number

The count on the rows is approc. 160 000. I started the update almost 2hours ago and it is still running. Is there a better/faster procedure to do mass updates on rows.

I'm using plsql developer...update t1 set col1=col2;

You are updating both columns in the same pass, aren't you? Your code fragment suggests you might not be.

you'd want to ...

Update
   My_Table
Set
   col1 = col2,
   col3= col4;

[stancho]

Originally posted by abhaysk
Use Merge

abhaysk what you mean here? I could not find nothing in the documentation about it?

[abhaysk]

Originally posted by stancho
abhaysk what you mean here? I could not find nothing in the documentation about it?

I guess u searched docs < 9.x ?

herez the link MERGE

Abhay.

[slimdave]

I don't think the merge operation is relevant to this question.

[abhaysk]

Why not

Its much faster than lagecy Update Statement.
It depends how you might want to use

Ok, original poster didnt mention he had Triggers on the table for UPDATE.