Hi.
Try using <> instead of writing not equal.
If you are trying to select all tables with some value - use
following :
select table_name,chain_cnt
from user_Tables
where chain_cnt is not NULL;
HTH. Michael.
In article <80l0m2$avm$1_at_nnrp1.deja.com>,
kehindet_at_my-deja.com wrote:
> 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.
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Sun Nov 14 1999 - 13:34:19 CST