Re: Top 10 solution in Oracle 8.0

Thanks for pointing out the error.
Don't know how it happened, I cut
and paste the whole thing from a
working script. (Blame it on M/S)

You must have missed the NB about 8i
in the first warning - I wouldn't do it this way in 8i at all since 8i supports 'order by' in views:

select *
from

    (select * from jpl_demo order by name) where rownum < 10
;

is all you need.

--

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Christopher Beck wrote in message
<37811c93.177704535_at_inet16.us.oracle.com>...
>On Wed, 30 Jun 1999 11:14:36 +0100, "Jonathan Lewis"

>One. Looks like you are missing a parenthesis in your query, opps.
>
>>select *
>>from
>> the
> ( -- this is needed
>> select
>> cast(
>> multiset(
>> select * from jpl_demo order by name
>> ) as junk_array
>> )
>> from dual
>> )
>>where rownum <= 3
>>;
>
>And two, in 8i, you can make this a bit simpler. You
>can turn the 'the( select() )' into 'TABLE'.
Received on Wed Jun 30 1999 - 09:20:44 CDT