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

Home -> Community -> Usenet -> c.d.o.server -> Re: Dynamic SQL-Command in PL/SQL

Re: Dynamic SQL-Command in PL/SQL

From: Jaap W. van Dijk <j.w.vandijk.removethis_at_hetnet.nl>
Date: Sat, 26 Feb 2005 12:07:34 +0100
Message-ID: <j0m0211h7j8unv3a14kfn9gjqdck211geu@4ax.com> 





On Fri, 25 Feb 2005 15:16:21 +0100, COAST <coast_at_cedes.com> wrote:



>It's not what I want.

>

>If myVar is null, I want ALL records otherwise I want only those records matching to myVar.

>

>Peter




If myVar is null, which records do you think are excluded with



where myVar is null or (myVar is not null and myNumber = myVar)?



Jaap.
Received on Sat Feb 26 2005 - 05:07:34 CST












Original text of this message













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