Re: Ordering on an inline-select statement

A copy of this was sent to "Jill" <jc_va_at_hotmail.com> (if that email address didn't require changing) On Sat, 28 Aug 1999 11:07:36 -0700, you wrote:

>Does this imply that a regularly-created view can be ordered in 8i?
>

yes.

tkyte_at_8i> create view emp_view as
  2 select ename, sal from emp order by sal   3 /

View created.

tkyte_at_8i> select * from emp_view;

ENAME SAL
---------- ----------

SMITH             792
JAMES           940.5
ADAMS            1089
WARD           1237.5
MARTIN         1237.5
MILLER           1287
TURNER           1485
ALLEN            1584
CLARK          2425.5
BLAKE          2821.5
JONES         2945.25
SCOTT            2970
FORD             2970
KING             4950

14 rows selected.

>
>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:31:55 CDT