This is happening 3rd time with me so I have to figure out what's wrong . When I issue the given sql first time  i get an error as shown . After that I copy and paste it again and it works second time . Any clue what should be the reason ? btw, it happens with any sql ..not just this one . Its on hp-ux 9000 server with 8.1.7.4 oracle. This doesn't if sql is issued from someother box .
 
 
SQL>
SQL>
SQL> select * from v$instance;
select * from v$instance
        *
ERROR at line 1:
ORA-00923: FROM keyword not found where expected
 

SQL> select * from v$instance;
 
INSTANCE_NUMBER INSTANCE_NAME
--------------- ----------------
HOST_NAME

Reply via email to