Re: rownum kills Order... Is there a solution ?

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 29 Jun 1999 22:57:08 +0100
Message-ID: <930693686.8520.0.nnrp-08.9e984b29@news.demon.co.uk>

I have a cute little trick that uses:

   select *

     from the (
        select
            cast(multiset(select cols from table order by ....) as o_type)
        from dual

    )
    where rownum <= NNN
;

However, I've just found a nasty little bug in it, so I won't go into more details just yet until I've checked it out further.

--

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

Pablo Picasso wrote in message <37786726.343653848_at_enews.newsguy.com>...
>Sorry,
>it is just version 8.0.5.0
>They always told me about 8.1.5 and that they want to upgrade to 8.1.6
>as soon as it is available, but now i realized that's only 8.0.5.0, so
>the sql doesn't work.
>Can you please tell me about using Object types to get a workaround ?
>
Received on Tue Jun 29 1999 - 16:57:08 CDT