Home » RDBMS Server » Performance Tuning » How to check for Null values
How to check for Null values [message #316232] Thu, 24 April 2008 06:01 Go to next message
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

Re: How to check for Null values [message #316257 is a reply to message #316232] Thu, 24 April 2008 07:07 Go to previous messageGo to next message
Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Prove it and this has nothing to do with performances.
Post explain plan.

Regards
Michel

[Updated on: Thu, 24 April 2008 07:08]

Report message to a moderator

Re: How to check for Null values [message #316287 is a reply to message #316257] Thu, 24 April 2008 08:27 Go to previous message
vkrn
Messages: 18
Registered: March 2008
Junior Member
I am sorry,i checked it later and i got it. Smile

Report message to a moderator

Previous Topic: Sql query tuning
Next Topic: check oracle job status
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Jun 27 21:33:33 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.