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

Home -> Community -> Mailing Lists -> Oracle-L -> selecting Null in parameter list

selecting Null in parameter list

From: Kathy Duret <kathy.duret_at_isearch.com>
Date: Wed, 15 Nov 2000 17:53:54 -0800
Message-Id: <10681.122212@fatcity.com>


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. Received on Wed Nov 15 2000 - 19:53:54 CST

Original text of this message

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