Re: Ordering on an inline-select statement

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Sat, 28 Aug 1999 14:33:11 GMT
Message-ID: <37d0f318.15093433@newshost.us.oracle.com>

A copy of this was sent to P Jeromel <pjeromel_at_hotmail.com> (if that email address didn't require changing) On Sat, 28 Aug 1999 09:43:26 +0930, you wrote:

>Re all,
>
>Just wondering if there is a way of ordering on an inline select.
>
>ie. select * from (select col1, col2, col3 from table_1 ORDER BY col1)
> where ...
>
>Thanks.
>Paul

In Oracle8i, release 8.1, yes.

Prior to that, no.

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Sat Aug 28 1999 - 09:33:11 CDT