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: Mark Powell <Mark.Powell_at_eds.com>
Date: 9 Apr 1998 12:47:41 GMT
Message-ID: <01bd63b6$40f15f40$a12c6394@J00679271.ddc.eds.com>


You can not use an order by clause in a view. Add the order by clause to the query against the view. You can use a group by clause in a view or sub-query.

Blinoff Dmitry <dbprok_at_ropnet.ru> wrote in article <01bd6389$e5447460$0a00a8c0_at_dmitry-nt>...
> Hello all!
>
> Does anybody know the way of using Order by clause in view
> or subquery ?
>
> --
> Dmitry, dbprok_at_ropnet.ru
>
Received on Thu Apr 09 1998 - 07:47:41 CDT

Original text of this message

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