Re: Passing a parameter to a Where Clause in PL/SQL !

From: Robert Chin <robert_chin_2000_at_hotmail.com>
Date: Mon, 10 Dec 2001 07:39:57 GMT
Message-ID: <hFZQ7.89220$MX1.13893615_at_news02.optonline.net>

> d_column = nvl(ai_str3, d_column)
> Would that work or what do you think I should do?

It works just fine if d_column has no nulls, now if it does, then those records will not be retrieved.

--
Robert Chin

Received on Mon Dec 10 2001 - 08:39:57 CET

This message: [ Message body ]
Next message: Gordon: "Forms 4.5 Code Extract"
Previous message: Giovanni Bronzini: "Re: Developer/2000 Saving Word Docs to Forms"
In reply to: Kavous Niamir: "Passing a parameter to a Where Clause in PL/SQL !"
Next in thread: MarkyG: "Re: Developer/2000 Saving Word Docs to Forms"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message