OraFAQ Forum: Performance Tuning » How to check for Null values

Home » RDBMS Server » Performance Tuning » How to check for Null values

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to check for Null values [message #316232]

Thu, 24 April 2008 06:01

vkrn
Messages: 18
Registered: March 2008

Junior Member

Hi All,

I have a table by name change_request_logs which have a column module_ref_id (varchar2(16).consider this query,

select distinct module_ref_id from change_request_logs where change_request_id=32565 and module_ref_id is not null

here change_request_id is the foriegn key.after running this query i am still getting the module_ref_id with null values .
can anyone help me.....

Thanks,
kiran.

Report message to a moderator