Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORACLE 8.1.5.i : Strange problem with SELECT COUNT(*) WHERE ... IS NULL
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
![]() |
![]() |