Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Ok in 8i SQL Plus - but ORA-00933 when creating a view !!!
Steve wrote:
> SOLVED,,, Take out the ORDER BY which is not allowed in a view. Steve
In 8i. It is perfectly good DDL in 9i or above.
-- Daniel A. Morgan http://www.psoug.org damorgan_at_x.washington.edu (replace x with u to respond)Received on Thu Jun 30 2005 - 08:57:21 CDT