Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Ordering on an inline-select statement
Does this imply that a regularly-created view can be ordered in 8i?
Thomas Kyte wrote in message <37d0f318.15093433_at_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 - 13:07:36 CDT