Re: ORDER BY in VIEW or SUBQUERY

in view you can not use order by, but you can do select col1,col2 from v_table where to_number(col1) >0;

Blinoff Dmitry wrote:

> 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 - 16:28:58 CDT