Re: SQL and boolean stuff

Bricklen wrote:

> CASE works fine on 817
>
> select case when 1=0 then 'no' when 1=1 then 'yes' else 'neither' end
> from dual;
>
> Does it not work for you?

In 8.1.7 it works in SQL but not in PL/SQL. In 9i it works in both.

The only way in 8.1.7 to use CASE in PL/SQL is with dynamic SQL.

-- 
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)