Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Create View and Order By?
Hello,
Does anyone know if it work when you create view as
select .....from ... where ....order by column_name?
'Cause when I create view and order by column_name,
an error occurs:ORA-00933: SQL command not properly ended.
Without order by the view was created successfully.
Couldn't view order by column_name?
Please Cc to :violin.hsiao_at_mail.pouchen.com.tw,Thank you :)
Received on Mon Aug 03 1998 - 01:55:42 CDT