Although you have a null in this which will explain strange behavior in
counting null's - I've just re-read your posting and it may be that you have
entered data into your table in worksheet and not committed it yet.. So your
sqlplus session sees nothing yet..
KJB
----- Original Message -----
From: "Rajavardhan "
<oracledba-ezmlmshield-x44293520.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Monday, April 30, 2007 12:26 PM
Subject: out put different


> Hi gurus
>
> I have table Test having only one column int type
>
>
>
> The data in the table is 1,2,3,null,4
>
>
>
> When run query using sql plus worksheet
>
> select * from test where n in(1,2,null);
>
>
>
> N
>
> ----------
>
> 1
>
> 2
>
>
>
> When run the same query in sql plus command prompt
>
>
>
> SQL> select * from test where n in(1,2,null);
>
>
>
> no rows selected
>
>
>
>
>
> plz give clear reason
>
>
>
>
>
> Thanks & Regards
>
>
>
> V.Rajavardhan Reddy
>
> Software Engineer
>
> GSS America Infotech Ltd.
>
> Block B, 3'rd Floor,
>
> Cyber Gateway,
>
> Hi-Tech City,
>
> Hyderabad.
>
> Tel:- 040-40028700
>
> Fax:- 040-40028703
>
> Visit us: http://www.gssamerica.com
>
>
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>


Oracle LazyDBA home page