Re: Help on Update query

On Jan 22, 6:45 pm, evil0ne <dlehr..._at_gmail.com> wrote:
> I need to move 490 records from a column named TRACKID to PS_NAME.
> After I do that I need to also set STATUS_CD to "RETIRED" and insert
> NULL values where the TRACKID used to be.  I have succesfully found
> the 490 records with the following select statement:
>
> SELECT
>   MASTER_INVENTORY."TRACKID",
>   MASTER_INVENTORY."MODEL",
>   MASTER_INVENTORY."STATUSCD",
>   MASTER_INVENTORY."PS_NAME"
> FROM
>   "SHIPWARE"."MASTER_INVENTORY" MASTER_INVENTORY
> WHERE
>   MASTER_INVENTORY."STATUSCD" IS NULL AND
>   MASTER_INVENTORY."TRACKID" != 'N/A'
>
> and I have been trying to make the following work based off of the
> example located athttp://www.psoug.org/reference/update.html:
>
> UPDATE MASTER_INVENTORY
> SET (MASTER_INVENTORY."PS_NAME",MASTER_INVENTORY."TRACKID") = (
>    SELECT (MASTER_INVENTORY."PS_NAME",MASTER_INVENTORY."TRACKID")
>    FROM "SHIPWARE"."MASTER_INVENTORY" MASTER_INVENTORY)
> WHERE MASTER_INVENTORY."STATUSCD" IS NULL AND
>   MASTER_INVENTORY."TRACKID" != 'N/A';
>
> Thanks for all the help.

A simple UPDATE statement like this might work: UPDATE
  SHIPWARE.MASTER_INVENTORY
SET
  PS_NAME = TRACKID,
  STATUSCD = 'RETIRED',
  TRACKID = NULL
WHERE
  MASTER_INVENTORY.STATUSCD IS NULL AND
  MASTER_INVENTORY.TRACKID != 'N/A'; Charles Hooper
IT Manager/Oracle DBA
K&M Machine-Fabricating, Inc. Received on Tue Jan 22 2008 - 18:26:09 CST