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.