Replace your data types with varchar2 and do it. Betcha it works then
Jim
--
Replace part of the email address: kennedy-down_with_spammers_at_attbi.com
with family. Remove the negative part, keep the minus sign. You can figure
it out.
"Oscar" <oscar_at_j.com> wrote in message
news:b130qi$hhd$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 - 04:28:14 CST
