RE: 2/28/01 - PL/SQL Syntax Request
random values! __ Pat Gorden-Ozgul BNL-ISD Systems [EMAIL PROTECTED] 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" <[EMAIL PROTECTED]> 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 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: William Beilstein 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
RE: 2/28/01 - PL/SQL Syntax Request
Well, it sounds like what you want to do is read the table into a cursor and if there is nothing else unique about the rows, the rowid. Then loop through the cursor checking for your true condition and if it is, then update the row, commit and continue until the cursor is empty. DECLARE CURSOR blah IS SELECT * FROM table; BEGIN FOR v_whatever IN blah LOOP IF v_whatever.column_name = xyz THEN UPDATE table SET column_name = new_whatever WHERE condition identifying this row as unique; COMMIT; END IF; END LOOP: END; You get the picture. There is also a cursor construct select for update which may be more appropriate. Dan -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). _ This message has been checked for all known viruses by UUNET delivered through the MessageLabs Virus Control Centre. For further information visit http://www.uk.uu.net/products/security/virus/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dasko, Dan 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 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).
RE: 2/28/01 - PL/SQL Syntax Request
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" <[EMAIL PROTECTED]> 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 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: William Beilstein 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).
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).