Queries with NULL (Oracle Parameters?)

I have an query p.e.

1. select customer,salary from employees where street is null

My result is not correct. If I use

2. select customer,salary from employees where nvl(street,'anything')='anything'

then the result of the query is correct. Exist in Oracle a

parameter to use the 'is null' operator like the 2nd query?

Thanks in advance. Received on Wed Jul 24 2002 - 01:29:01 CDT