2/28/01 - PL/SQL Syntax Request
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 31 CA IND 31 PH IND 11 CA IND 14 PH OUT 11 CA IND 31 ... ... The data table OUT (after processing): Col1 Col2 Col3 Col4 Col5 Col6 Col7 Col8 Col9 CA IND 31 CZ STA OFF REP AD CA IND 31 CZ STA OFF REP AD PH IND 11 PH STA OFF BOO PO CA IND 14 CZ STA OFF AV AD PH OUT 11 PH REF NULL RBO PO CA IND 31 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).
RE: 2/28/01 - PL/SQL Syntax Request
You put the following in a table (could be temporary): 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 And then joing it to the original table (or use NL) to update it. -Original Message- Sent: Wednesday, February 28, 2001 11:41 AM To: Multiple recipients of list ORACLE-L 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 31 CA IND 31 PH IND 11 CA IND 14 PH OUT 11 CA IND 31 ... ... The data table OUT (after processing): Col1 Col2 Col3 Col4 Col5 Col6 Col7 Col8 Col9 CA IND 31 CZ STA OFF REP AD CA IND 31 CZ STA OFF REP AD PH IND 11 PH STA OFF BOO PO CA IND 14 CZ STA OFF AV AD PH OUT 11 PH REF NULL RBO PO CA IND 31 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: Khedr, Waleed 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).
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. [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 31 CA IND 31 PH IND 11 CA IND 14 PH OUT 11 CA IND 31 ... ... The data table OUT (after processing): Col1 Col2 Col3 Col4 Col5 Col6 Col7 Col8 Col9 CA IND 31 CZ STA OFF REP AD CA IND 31 CZ STA OFF REP AD PH IND 11 PH STA OFF BOO PO CA IND 14 CZ STA OFF AV AD PH OUT 11 PH REF NULL RBO PO CA IND 31 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).
