Hi All,

When I was writing a query accidentally I missed the 'SELECT' statement in the query but was surprised Oracle didn't report any error, neither any results. Then I tried all the following, none of them reports any error. How does the parser treat this? Looks like it is ignored in SQL*Plus itself?(The query doesn't seem to be submitted even though it is terminated with a semi colon.A '/' after all these statements however throws an error). Any thoughts?

11:51:40 SQL> * from emp;
11:51:52 SQL> *
Invalid line number
11:51:57 SQL> * from ;
11:52:03 SQL> * from
11:52:09 SQL> * from emp where empno= 7128;
11:52:30 SQL>
11:52:30 SQL> * from emp a, dept b where a.deptno = b.deptno;
11:56:07 SQL>

12:03:25 SQL> * from emp;
12:03:50 SQL> /
from emp
*
ERROR at line 1:
ORA-00900: invalid SQL statement

Nandu