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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: SQL statement

Re: SQL statement

From: <jo_holvoet_at_amis.com>
Date: Tue, 26 Oct 2004 20:22:23 +0200
Message-id: <OF7C785BC7.116DCBA2-ONC1256F39.0064E529@eu.amis.com>


Does "select qid from login" also return null values ?

mvg/regards

Jo

"Rusnak, George A. (SEC-Lee) CTR" <george.rusnak_at_deca.mil> Sent by: oracle-l-bounce_at_freelists.org
10/26/2004 20:11
Please respond to george.rusnak  

        To:     "'oracle-l_at_freelists.org'" <oracle-l_at_freelists.org>
        cc: 
        Subject:        SQL statement


Does anyone have any ideas why this is not working ???

pweb:acedmgr> select QID from login;

       QID


         1
         1



pweb:acedmgr> select qid from question;

       QID


         2
         3
         1

pweb:acedmgr> SELECT qid 
                        FROM    question
  2                    WHERE  qid NOT IN (SELECT qid FROM login);

no rows selected


pweb:acedmgr> desc login

 Name                                      Null?    Type
 ----------------------------------------- -------- ---------------
 USER_ID                                   NOT NULL VARCHAR2(20)
 PSWD                                      NOT NULL VARCHAR2(32)
 PSWD_CHG_DTE                                       DATE
 LAST_NAME                                 NOT NULL VARCHAR2(30)
 FIRST_NAME                                NOT NULL VARCHAR2(30)
 LOCKED                                             VARCHAR2(1)
 CREATED_BY                                NOT NULL VARCHAR2(20)
 CREATED_DTE                               NOT NULL DATE
 QID                                                NUMBER(6)
 ANSWER                                             VARCHAR2(100)
 USER_ROLE                                          VARCHAR2(1)

pweb:acedmgr> desc question
 Name                                      Null?    Type
 ----------------------------------------- -------- --------------
 QID                                       NOT NULL NUMBER(6)
 QUESTION                            NOT NULL VARCHAR2(200)

=================================================================

TIA Al Rusnak
DBA - CISIS, Computer Operations

--
http://www.freelists.org/webpage/oracle-l



--
http://www.freelists.org/webpage/oracle-l
Received on Tue Oct 26 2004 - 13:18:04 CDT

Original text of this message

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