RE: selecting Null in parameter list

From: Djordje Jankovic <djankovic_at_corp.attcanada.ca>
Date: Thu, 16 Nov 2000 00:02:03 -0500
Message-Id: <10681.122219@fatcity.com>

I am not quite getting what you want, but couldn't you use nvl function, something like:

  A.sourcetext like (decode(nvl(:P_sourcetext,'*'),'*','%',:P_sourcetext))  

Djordje

-----Original Message-----
From: Kathy Duret
To: Multiple recipients of list ORACLE-L Sent: 11/15/00 8:45 PM
Subject: selecting Null in parameter list

For oracle 6i

My parameter query is

select distinct sourcetext from table_all union select * from dual

Which shows a blank or Null selection with the other values

This is in my query where clause

   A.sourcetext like (decode(:P_sourcetext,'*','%',:P_sourcetext))

How to I fix the where clause so that if null values are present in the parameter list, when the user selects the Null value from the drop down list
or
selects * (to get all the values) the report will show null values.

Kathy

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Kathy Duret
  INET: kathy.duret_at_isearch.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Nov 15 2000 - 23:02:03 CST