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
Oracle LazyDBA home page