Re: Top 10 solution in Oracle 8.0

From: Christopher Beck <clbeck_at_us.oracle.com>
Date: Wed, 30 Jun 1999 13:44:13 GMT
Message-ID: <37811c93.177704535@inet16.us.oracle.com>

On Wed, 30 Jun 1999 11:14:36 +0100, "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote:

Jonathan,

FYI. 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'.

select *
  from TABLE (

               cast(
                     multiset( 
                               select * from jpl_demo order by name
                             ) as junk_array
                    )
             )

 where rownum <= 3
;

chris.

--
Christopher Beck
Oracle Corporation
clbeck_at_us.oracle.com
Reston, VA.

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Wed Jun 30 1999 - 08:44:13 CDT