Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Urgent Empty Field

Re: Urgent Empty Field

From: Marc Mazerolle <informaze_at_videotron.ca>
Date: Mon, 13 Dec 1999 19:49:28 GMT
Message-ID: <38554E84.7B62762D@videotron.ca>


Eric,

Try this :

('" & value &"' <> '' and no_app = '" & value & "') or ('" & value &"' = '' and no_app is null)"

quotes might be a little off but you get the picture.... the optimizer will do the rest of the job.

Salut et bonne journee,

Marc Mazerolle
InforMaze Inc.

Eric Caron wrote:

> Here's my problem, in my database, I have field with NULL value and I must
> compare these fields with empty value like this :
>
> no_app='" & value & "'"
>
> This return no row, I try NVL(no_app,'')='" & value & "'" and this don't
> work too
>
> Do you have a solution thanks
>
> --
> Eric Caron
> Programmeur-analyste
> PG Systèmes d'Information
> 217 Léonidas
> Rimouski, QC
> Canada
> http://www.pgsystem.com
Received on Mon Dec 13 1999 - 13:49:28 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US