Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ORDER BY in VIEW or SUBQUERY

Re: ORDER BY in VIEW or SUBQUERY

From: Jonathan Gennick <gennick_at_worldnet.att.net>
Date: Sat, 11 Apr 1998 01:46:17 GMT
Message-ID: <6gmi22$9kk@bgtnsc03.worldnet.att.net> 





On 9 Apr 1998 07:34:01 GMT, "Blinoff Dmitry"
<dbprok_at_ropnet.ru> wrote:



>Does anybody know the way of using Order by clause in view


>or subquery ?





You basically can't. In a subquery, order should not matter,
should it? As for a view, you need to specify the sort order
when you select from the view.



Jonathan


Received on Fri Apr 10 1998 - 20:46:17 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US