Re: create view & order by clause

Hi,
Views are unsorted. The order by clause is not permitted in views.

Regards
Peter H. Larsen (petlars_at_pip.dknet.dk) Oracle Consultant (not affiliated with Oracle)

On 30 Jan 1998 21:31:33 GMT, dipen_at_dcs.rhbnc.ac.uk ( D. Shah) wrote:

> select flight_id
> from avail
> where flight_id in
> (select flight_id
> from itin)
> order by flight_date;
>
>works fine.
>
>But when I add the following code...
>
>create view itin_view
>as
> select flight_id
> from avail
> where flight_id in
> (select flight_id
> from itin)
> order by flight_date;
>
>
>...I get the following error:
>
> order by flight_date
> *
>ERROR at line 8:
>ORA-00907: missing right parenthesis
>
>Can anyone see what I'm doing wrong?
>
>Many thanks in advance.
>
>Dipen
>
>PS Thank you to all the people that have helped me in my previous queries!
Received on Sat Jan 31 1998 - 00:00:00 CET