| 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
random values!
Pat Gorden-Ozgul BNL-ISD Systems gorden_at_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" <Waleed.Khedr_at_FMR.COM> 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_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: Khedr, Waleed INET: Waleed.Khedr_at_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_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: William Beilstein INET: BeilstWH_at_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_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: 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).Received on Wed Feb 28 2001 - 13:36:03 CST
 |
 |