From gorden@bnl.gov Wed, 28 Feb 2001 11:36:03 -0800 From: "Gorden-Ozgul, Patricia E" Date: Wed, 28 Feb 2001 11:36:03 -0800 Subject: RE: 2/28/01 - PL/SQL Syntax Request Message-ID: MIME-Version: 1.0 Content-Type: text/plain random values! __________________________________________________ Pat Gorden-Ozgul BNL-ISD Systems gorden@bnl.gov 631-344-5159 -----Original Message----- Sent: Wednesday, February 28, 2001 1:22 PM To: Multiple recipients of list ORACLE-L Are there rules on what the combination of key, A, M, and C produce or can each mixture of the for key values be any random value? >>> "Khedr, Waleed" 02/28/01 12:35PM >>> 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 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@bnl.gov 631-344-5159 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gorden-Ozgul, Patricia E INET: gorden@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@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: Khedr, Waleed INET: Waleed.Khedr@FMR.COM 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@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: William Beilstein INET: BeilstWH@obg.com 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@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: Gorden-Ozgul, Patricia E INET: gorden@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@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).