Message-Id: <22541.293604@fatcity.com> From: "Markham, Richard" Date: Wed, 11 Sep 2002 14:36:30 -0400 Subject: RE: Decode This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C259C2.255CEE50 Content-Type: text/plain; charset="iso-8859-1" an example straight from 9i SQL Reference should do SELECT product_id, DECODE (warehouse_id, 1, 'Southlake', 2, 'San Francisco', 3, 'New Jersey', 4, 'Seattle', 'Non-domestic') quantity_on_hand FROM inventories; -----Original Message----- From: Ruth Gramolini [mailto:rgramolini@tax.state.vt.us] Sent: Wednesday, September 11, 2002 2:59 PM To: Multiple recipients of list ORACLE-L Subject: Decode Hello everyone, I am having a senior moment and I have forgetten the syntax for 'decode'. Can anyone give me a hint. I have leant out my sql books and of course I need them now. Thanks in advance, Ruth Gramolini Oracle DBA, Vermont Department of Taxes -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: rgramolini@tax.state.vt.us 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). ------_=_NextPart_001_01C259C2.255CEE50 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: Decode

an example straight from 9i SQL Reference should = do

SELECT product_id,
       DECODE = (warehouse_id, 1, 'Southlake',
          &nb= sp;           &nb= sp;      2, 'San Francisco',
          &nb= sp;           &nb= sp;      3, 'New Jersey',
          &nb= sp;           &nb= sp;      4, 'Seattle',
          &nb= sp;           &nb= sp;         'Non-domestic') =
       = quantity_on_hand FROM inventories;


-----Original Message-----
From: Ruth Gramolini [mailto:rgramolini@tax.state.v= t.us]
Sent: Wednesday, September 11, 2002 2:59 PM
To: Multiple recipients of list ORACLE-L
Subject: Decode


Hello everyone,

I am having a senior moment and I have forgetten the = syntax for 'decode'.
Can anyone give me a hint.  I have leant out my = sql books and of course I
need them now.

Thanks in advance,
Ruth Gramolini
Oracle DBA, Vermont Department of Taxes

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ruth Gramolini
  INET: rgramolini@tax.state.vt.us

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 =