Re: Oracle 8i SQL Statement

Kent Prokopy wrote:

>When using the DECODE function, is there any way of passing it the
>IN() clause?
>
>Example:
>DECODE(FIELDNAME,IN(1,2,3),TRUE,FALSE)
>
>This returnning TRUE if the values of 1, 2 or 3 are found. So far the
>only way I can get this to work is as follows:
>
>DECODE(FIELDNAME,1,TRUE,2,TRUE,3,TRUE,FALSE) "This leaving a lot of
>room for typo errors."
>
>Thank you.
>Kent Prokopy
>
>

What is it you expect as the output? True if it is any one of the three values presented?

If so use the CASE statement but you must do it in SQL*Plus, not a PL/SQL procedure, unless you do it as dynamic SQL. As of v9 you can do it in PL/SQL directly.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)