help please

From: Oscar <oscar_at_j.com>
Date: Mon, 27 Jan 2003 11:18:40 +0100
Message-ID: <b130qt$hjj$1_at_nsnmrro2-gest.nuria.telefonica-data.net>

[Quoted] [Quoted] I create a tabe. Then I insert some values, when I make the query = i got 1 [Quoted] 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,
[Quoted]     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)
;

[Quoted] insert into xcola values ('0','SERVIDOR' ,'CGAUTO','PARADA','GL215','','0',' ','1')
;

[Quoted] 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)
[Quoted] 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:18:40 CET