dbTalk Databases Forums  

Help on Update query

Go Back dbTalk Databases Forums Databases comp.databases.oracle.misc Help on Update query

comp.databases.oracle.misc comp.databases.oracle.misc


Discuss Help on Update query in the comp.databases.oracle.misc forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
evil0ne
 
Posts: n/a

Default Help on Update query - 01-22-2008 , 05:45 PM





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 at http://www.psoug.org/reference/update.html:

UPDATE MASTER_INVENTORY
SET (MASTER_INVENTORY."PS_NAME",MASTER_INVENTORY."TRAC KID") = (
SELECT (MASTER_INVENTORY."PS_NAME",MASTER_INVENTORY."TRAC KID")
FROM "SHIPWARE"."MASTER_INVENTORY" MASTER_INVENTORY)
WHERE MASTER_INVENTORY."STATUSCD" IS NULL AND
MASTER_INVENTORY."TRACKID" != 'N/A';

Thanks for all the help.

Reply With Quote
  #2  
Old   
Charles Hooper
 
Posts: n/a

Default Re: Help on Update query - 01-22-2008 , 06:26 PM





On Jan 22, 6:45*pm, evil0ne <dlehr... (AT) gmail (DOT) com> wrote:
Quote:
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."TRAC KID") = (
* *SELECT (MASTER_INVENTORY."PS_NAME",MASTER_INVENTORY."TRAC KID")
* *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.


Reply With Quote
  #3  
Old   
Charles Hooper
 
Posts: n/a

Default Re: Help on Update query - 01-22-2008 , 06:26 PM


On Jan 22, 6:45*pm, evil0ne <dlehr... (AT) gmail (DOT) com> wrote:
Quote:
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."TRAC KID") = (
* *SELECT (MASTER_INVENTORY."PS_NAME",MASTER_INVENTORY."TRAC KID")
* *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.


Reply With Quote
  #4  
Old   
Charles Hooper
 
Posts: n/a

Default Re: Help on Update query - 01-22-2008 , 06:26 PM


On Jan 22, 6:45*pm, evil0ne <dlehr... (AT) gmail (DOT) com> wrote:
Quote:
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."TRAC KID") = (
* *SELECT (MASTER_INVENTORY."PS_NAME",MASTER_INVENTORY."TRAC KID")
* *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.


Reply With Quote
  #5  
Old   
Charles Hooper
 
Posts: n/a

Default Re: Help on Update query - 01-22-2008 , 06:26 PM


On Jan 22, 6:45*pm, evil0ne <dlehr... (AT) gmail (DOT) com> wrote:
Quote:
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."TRAC KID") = (
* *SELECT (MASTER_INVENTORY."PS_NAME",MASTER_INVENTORY."TRAC KID")
* *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.


Reply With Quote
  #6  
Old   
evil0ne
 
Posts: n/a

Default Re: Help on Update query - 01-23-2008 , 09:48 AM


Thanks for the help, that definitely worked. I'm not a SQL person and
the first google result was making it way too difficult. Thanks again.

Reply With Quote
  #7  
Old   
evil0ne
 
Posts: n/a

Default Re: Help on Update query - 01-23-2008 , 09:48 AM


Thanks for the help, that definitely worked. I'm not a SQL person and
the first google result was making it way too difficult. Thanks again.

Reply With Quote
  #8  
Old   
evil0ne
 
Posts: n/a

Default Re: Help on Update query - 01-23-2008 , 09:48 AM


Thanks for the help, that definitely worked. I'm not a SQL person and
the first google result was making it way too difficult. Thanks again.

Reply With Quote
  #9  
Old   
evil0ne
 
Posts: n/a

Default Re: Help on Update query - 01-23-2008 , 09:48 AM


Thanks for the help, that definitely worked. I'm not a SQL person and
the first google result was making it way too difficult. Thanks again.

Reply With Quote
Reply

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top