Forum Stats

  • 3,876,254 Users
  • 2,267,083 Discussions
  • 7,912,483 Comments

Discussions

Passing null value into blank value field through Oracle BI Query

DILIP KAMALON
DILIP KAMALON Member Posts: 1 Green Ribbon

Hai,

How can i Pass null value into blank value field through Oracle BI Query.

below is my query which is not giving any result if am passing null value, how can this query modify which allows null value.

and trunc(rsh.creation_date) between nvl((:p_purcahse_From),trunc(rsh.creation_date))and nvl((:p_purcahse_To),trunc (rsh.creation_date) )


p_purcahse_From and p_purcahse_To date is the parameter value which am passing from my BI report. Creation date sometimes blank so whenever it blank parameter should pass as null value


Please help.