"Rob C" <rchin_at_panix.com> wrote in message news:<c7orv6$1jo$1_at_reader2.panix.com>...
> > I couldn't agree with you more. However, the CASE function is not
> > available in all Oracle versions.
>
> But....what's the point ? I mean 8.0.x is long outta support....
> anyone stuck on using ancient sw is missing a shit lot more than
> just CASE.
>
> It's like tossing a kiddie-pool toy to someone in a raging Atlantic
> storm...; )
Even later versions (I have 8.1.7.3.0 here at work) don't support CASE
within PL/SQL. Of course there are work-arounds, like creating a view
or using dynamic SQL. But unless there were compelling reasons to do
otherwise, I'd happily use a DECODE.
Received on Tue May 11 2004 - 07:06:42 CDT
