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]