How to update column

Forum|Forum|7 years ago
June 3, 2019
5 replies
4 views

Testudinateklev
New Participant

Dear All,

Could you please advice me how I can update one column on my big table using values column on different table.

For example , I used MERGE JOIN operation but it is not work when I have duplicates

Also, I try to use this constructions :

ALTER TABLE facts.Orders_merge DROP COLUMN AppointedPhone;

ALTER TABLE facts.Orders_merge ADD COLUMN AppointedPhone varchar(64)
DEFAULT (SELECT AppointedPhone FROM facts.Orders_add_column_merge WHERE facts.Orders_add_column_merge.HashOrderId=facts.Orders_merge.HashOrderId);

HashOrderId - It is PK.

I can not drop this table facts.Orders_add_column_merge.

On my case I want to copy "AppointedPhone" from my stage table to big table fastly.

Thanks all in advance.

+1

SruthiA
Participating Frequently
Forum|Forum|7 years ago
June 3, 2019

What is the issue you are facing with the method you tried?

Like

+2

Jim_Knicely
Participating Frequently
Forum|Forum|7 years ago
June 3, 2019

@Testudinateklev

Are you sure you want a flattened table? Maybe you just want an UPDATE?

Example:

UPDATE /*+ DIRECT */
       facts.Orders_merge
   SET AppointedPhone = (SELECT AppointedPhone 
                           FROM facts.Orders_add_column_merge
                          WHERE facts.Orders_merge.HashOrderId = facts.Orders_add_column_merge.HashOrderId);