Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Really need HELP !

Really need HELP !

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US