Re: Decode

"Connor McDonald" <connor_mcdonald_at_yahoo.com> wrote in message news:3CB09ABC.7B83_at_yahoo.com...
> Jonathan Lewis wrote:
> >
> > Unfortunately, CASE only exists in 8.1.6+.
> And interestingly the 9i documentation indicates that decode is
> "deprecated", which I typically read to mean "when we recode the 37654
> decode statments in the data dictionary, we can get rid of it"

I've always read that as

'when we get rid of the 12451244 pieces of code that use it then we can get rid of it subject to the following 2 conditions 1. we can be bothered,
2. we remember

but you mustn't ever use it ever - and don't forget it'

--
Niall Litchfield
Oracle DBA
Audit Commission UK