| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: 2/28/01 - PL/SQL Syntax Request
How about:
update <table_name> set
col5 = decode(string1,string2,'PH',string3 'CZ',).
,col6 = decode(string4,string5,'STA',string6, 'REF',) ,col7 = etc ,col8 = etc
string1 and string4, etc could be the concatentation of the four determinant columns, string 2,3,5,6, etc would be the determining values.
>>> gorden_at_bnl.gov 02/28/01 11:41AM >>>
I need help. I'm sorry if this is a cross-posting for you.
I'd like to see some example PL/SQL code, perhaps a procedure, that will
pass
through each record of a table, test for combinations of column values and
based upon
a specific value (which would be determined by an IF... THEN... matrix), set
a variable.
The value stored in this variable would then be used to update a different
column of the
very same table from which the original record was read.
The matrix:
(IF) (THEN) Key A M C one two three four five CA IND 1 1 CZ STA OFF BOO AD CA IND 3 1 CZ STA OFF REP AD CA IND 1 4 CZ STA OFF AV AD
...
PH IND 1 1 PH STA OFF BOO PO PH OUT 1 1 PH REF NULL RBO PO
The data table IN (before processing):
Col1 Col2 Col3 Col4 Col5 Col6 Col7 Col8 Col9
CA IND 3 1 CA IND 3 1 PH IND 1 1 CA IND 1 4 PH OUT 1 1 CA IND 3 1
The data table OUT (after processing):
Col1 Col2 Col3 Col4 Col5 Col6 Col7 Col8 Col9
CA IND 3 1 CZ STA OFF REP
AD
CA IND 3 1 CZ STA OFF REP
AD
PH IND 1 1 PH STA OFF BOO
PO
CA IND 1 4 CZ STA OFF AV
AD
PH OUT 1 1 PH REF NULL RBO
PO
CA IND 3 1 CZ STA OFF REP
AD
...
...
I'm looking for the PL/SQL code syntax to perform a task such as this.
Wow. That was a mouthful. Good discipline.
Any and all help will be appreciated.
Pat Gorden-Ozgul BNL-ISD Systems gorden_at_bnl.gov 631-344-5159
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gorden-Ozgul, Patricia E INET: gorden_at_bnl.gov Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Sawmiller INET: sawmillert_at_state.mi.us Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Wed Feb 28 2001 - 13:13:14 CST
 |
 |