Re: help please

Hi there,

I think the problem is that you a querying a field that contains null values. try something like this...

select count(*) from xcola where programa <> 'GL215' or programa is null

Allan

"Oscar" <oscar_at_j.com> wrote in message news:b130qt$hjj$1_at_nsnmrro2-gest.nuria.telefonica-data.net...
> I create a tabe. Then I insert some values, when I make the query = i got
1
> row but what about diferent ?
>
> drop table XCOLA
> ;
> CREATE TABLE XCOLA (
> IDEN CHAR (7) NULL,
> EQUIPNAME CHAR (20) NULL,
> COLANAME CHAR (20) NULL,
> ESTADO CHAR (20) NULL,
> PROGRAMA CHAR (20) NULL,
> SUBSIST CHAR (20) NULL,
> PID CHAR (10) NULL,
> FIPROGRA CHAR (20) NULL,
> NUMPROCE CHAR (5) NULL)
> ;
> CREATE UNIQUE INDEX IXCOLA ON XCOLA (IDEN, EQUIPNAME, COLANAME)
> ;
> insert into xcola values ('0','SERVIDOR'
,'CGAUTO','PARADA','GL215','','0','
> ','1')
> ;
> insert into xcola values ('0','SERVIDOR' ,'CGJOBD','ACTIVA','','','0','
> ','1')
> ;
> insert into xcola values ('0','SERVIDOR' ,'CGJOBQ','ACTIVA','','','0','
> ','1')
> ;
> insert into xcola values ('0','SERVIDOR' ,'CGPOST','ACTIVA','','','0','
> ','1')
> ;
> select count(*) from xcola
> ;
> select count(*) from xcola where programa='GL215'
> ;
> select count(*) from xcola where programa<>'GL215'
> ;
>
> Select 1 --> 4 rows (ok)
> Select 2 --> 1 row (ok)
> Select 3 --> 0 row ( it should be 3) ???????????????? What i'm
> doing wrong !
> I'm using ORACLE 8.1.7 but with 9.2 same !!!!!
>
>
> Thank's OSCAR.
>
>
Received on Mon Jan 27 2003 - 11:49:10 CET