Update 2

[CIMTEET]

Can multiple fields be updated at the same time without using a FOR UPDATE?

 

[LKBrwnDBA]

Yes:

UPDATE MyTable
    SET Col1 = Val1, Col2 = Val2;
-- or --
UPDATE MyTable
   SET (Col1, Col2) = (
       Select Fld1, Fld2 From OtherTable
         Where {condition};

----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[CIMTEET]

What if I want to make it a many to one relationship. Multiple fields to the same value?

 

[SantaMufasa]

Do you mean multiple fields in the same table? If so, you certainly may do so. Using LK's earlier code:

UPDATE MyTable
    SET Col1 = <same value>
       ,Col2 = <same value>
       ...;
-- or --
UPDATE MyTable
   SET (Col1, Col2,...) = (
       Select <same value>, <same value>,... From OtherTable
         Where {condition};

Is this what you meant?

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[CIMTEET]

No. I already have the data from a previous query. I wanted to place one value in both of the table columns like this:

UPDATE MyTable
SET (Col1, Col2,...) = (n_system_track_id) where blah blah;

I tried it but it said that it had to be a subquery. I probably ought to type the code in here. I am developing on a unix machine and all data extraction routes are purposely blocked if you understand my drift.

 

[LKBrwnDBA]

Like this?

UPDATE MyTable
   SET Col1 = n_system_track_id
     , Col2 = n_system_track_id
 WHERE blah blah;

----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[james777]

UPDATE MyTable
SET (Col1, Col2,...) = (SELECT n_system_track_id , n_system_track_id FROM ( Your Query) );

 

[CIMTEET]

LKB,
Yeah, I wasn't sure about the syntax, thats exactly what I need if that works. The n_system_track_id was data retreived from a previous query. Thanks.