Re: Comparing NULL values

From: Kenny Gump <kgump_at_mylanlabs.com>
Date: Mon, 14 Jun 1999 13:24:27 -0400
Message-ID: <37653ad8.0_at_news.mountain.net>


In you comparison use the NVL function:

if nvl(p_In_parameter, '~') = v_comparator then ...
end if;

Kenny Gump

Meinaz wrote in message <01beb42c$a0114680$6b8374cb_at_default>...
>Hi folks,
>
>I need to execute an SQL statement in one of my PL/SQL script. In this
>statement i need to compare my column value with one of the IN parameter
>value. The IN parameter value may be null. In this case I will not be
>able to get a match even though my column value is null. Is there a way I
>can resolve this?
>
>THANX!!
>
>
>meinaz
Received on Mon Jun 14 1999 - 19:24:27 CEST

Original text of this message