Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ORACLE 8.1.5.i : Strange problem with SELECT COUNT(*) WHERE ... IS NULL

Re: ORACLE 8.1.5.i : Strange problem with SELECT COUNT(*) WHERE ... IS NULL

From: Genoud <tgenoud_at_cisel.ch>
Date: Wed, 22 Sep 1999 10:55:48 +0200
Message-ID: <7sa5ij$ka$1@pollux.ip-plus.net>


I save the rows in a temp table, drop and recreate the table, reinsert the saved rows and recreate the index...
Now it works again...
Strange ...

Mario Bucsics a écrit dans le message
<03aa077e.8c092907_at_usw-ex0102-010.remarq.com>...
>
>Hi
>
>
>I don´t know if this works but you could try it:
>
>select count(etat) from table_name where etat is null;
>
>
> Mario Bucsics
>
>* Sent from RemarQ http://www.remarq.com The Internet's Discussion Network
*
>The fastest and easiest way to search and participate in Usenet - Free!
>
Received on Wed Sep 22 1999 - 03:55:48 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US