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?
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
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.
Previous Topic: sql append
Next Topic: select into a variable problem
Goto Forum:
  


Current Time: Sun Dec 11 00:12:05 CST 2016

Total time taken to generate the page: 0.07156 seconds