Help please !

From: Oscar <oscar_at_j.com>
Date: Mon, 27 Jan 2003 11:18:29 +0100
Message-ID: <b130qi$hhd$1@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:18:29 CST