Oracle 8.0.5.2 on Solaris 2.6 -- invalid SQL raises 3113

From: <kehindet_at_my-deja.com>
Date: Sun, 14 Nov 1999 00:44:51 GMT
Message-ID: <80l0m2$avm$1@nnrp1.deja.com>

chain_cnt is of datatype number

---

SQL> select table_name,chain_cnt
  2 from user_Tables
  3 where chain_cnt is not equal 0;
select table_name,chain_cnt
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel

SQL*Plus: Release 8.0.5.0.0 - Production on Sat Nov 13 16:34:49 1999

(c) Copyright 1998 Oracle Corporation. All rights reserved.

Connected to:
Oracle8 Enterprise Edition Release 8.0.5.2.0 - Production PL/SQL Release 8.0.5.2.0 - Production

SQL> select * from v$version;

BANNER

---

Oracle8 Enterprise Edition Release 8.0.5.2.0 - Production PL/SQL Release 8.0.5.2.0 - Production
CORE Version 4.0.5.0.0 - Production
TNS for Solaris: Version 8.0.5.0.0 - Production NLSRTL Version 3.3.2.0.0 - Production

---

SQL> l
  1 select table_name,chain_cnt
  2 from user_tables
  3* where chain_cnt is not equal 0
SQL> /
where chain_cnt is not equal 0

                       *

ERROR at line 3:
ORA-00908: missing NULL keyword

SQL> select * from v$version;

BANNER

---

Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production PL/SQL Release 8.1.5.0.0 - Production
CORE Version 8.1.5.0.0 - Production
TNS for 32-bit Windows: Version 8.1.5.0.0 - Production NLSRTL Version 3.4.0.0.0 - Production

SQL> Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sat Nov 13 1999 - 18:44:51 CST