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.
>>> [EMAIL PROTECTED] 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
[EMAIL PROTECTED] 631-344-5159
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Gorden-Ozgul, Patricia E
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
