| 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: Decode
Ruth - Google! Google!
Decode
Oracle's handy decode function works as follows:=20
decode(expr, search, expr[, search, expr...] [, default])
To evaluate this expression, Oracle compares expr to each search value =
one
by one. If expr is equal to a search, Oracle returns the corresponding
result. If no match is found, Oracle returns default, or, if default is
omitted, returns null.=20
=A0
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com <mailto:dwilliams_at_lifetouch.com>=20
-----Original Message-----
From: Ruth Gramolini [mailto:rgramolini_at_tax.state.vt.us]
Sent: Wednesday, September 11, 2002 1: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
--=20
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--=20
Author: Ruth Gramolini
INET: rgramolini_at_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_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 Sep 11 2002 - 13:26:18 CDT
 |
 |