And I wonder when LONG columns (eg. trigger$
and view$) are going to disappear from the data
dictionary ? Not to mention the /*+ rule */ hint.
--
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
Author of:
Practical Oracle 8i: Building Efficient Databases
Niall Litchfield wrote in message
<3cb1fbad$0$8511$cc9e4d1f_at_news.dial.pipex.com>...
>"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
>
>
Received on Mon Apr 08 2002 - 15:25:42 CDT
