Home » SQL & PL/SQL » SQL & PL/SQL » Find a row with NULL Value
Find a row with NULL Value [message #354767] Tue, 21 October 2008 03:14 Go to next message
revathyeswar
Messages: 2
Registered: October 2008
Junior Member
Can you show an example to find a row where one column has a value and null value in another colummn in where clause.

For Example:
Select Employee_Id from Employee where Employee_Name='Roshan' and Employee_City=' '

Is this possible?
Else how to get this Employee_Id using the null value in city?

Report message to a moderator

Re: nvl in where clause [message #354771 is a reply to message #354767] Tue, 21 October 2008 03:21 Go to previous messageGo to next message
joicejohn
Messages: 327
Registered: March 2008
Location: India
Senior Member
@revathyeswar,

Try going through IS NULL.


Regards,
Jo

Report message to a moderator

Re: nvl in where clause [message #354902 is a reply to message #354771] Tue, 21 October 2008 23:04 Go to previous message
revathyeswar
Messages: 2
Registered: October 2008
Junior Member
Thanks jo.

Report message to a moderator

Previous Topic: sql append
Next Topic: select into a variable problem
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Dec 04 18:05:10 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.