-
I am trying to create a view using a select statment
which has order by clause. I keep getting this message
ORA-00933: SQL command not properly ended.
if I take out order by from the select it works fine.
Any Idea on how to do create views with order by??
thanks in advance
-
No in views you can give order by
Radhakrishnan.M
-
here is the statment I am using
SQL> ed
Wrote file afiedt.buf
1 create or replace view test_v as
2 select obl_num from obl
3* order by obl_num
SQL> /
order by obl_num
*
ERROR at line 3:
ORA-00933: SQL command not properly ended
[Edited by ocpdude on 11-08-2000 at 02:09 PM]
-
While u r editing , make sure that the script ends with /
i.e in ur edit file
it should be like
create or replace view test_v as
select obl_num from obl
order by obl_num
/
Hope it helps..
-
You cannot create view with order by clause. Oracle does not support this.
-
Oracel supports order by in views in Oracle 8i.
-
Thanks !
yes it works in 8i .I just tried it...
Radhakrishnan.M
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|