I want to make a jasper report used oracle db, and the condition is manual input,
if not input condition , display all the data,
if input condition ,and the condition maybe multi,
like '33,998',not include the ',
the problem is the col 'abab8' is number type, maybe the NVL return '33,998',include the ',
so i can't get the correct result,
if i use to_char(aban8), then i have no result..
any one can help me ,PLS.
select aban8,abalph from proddta.f0101
where ABAT1='V'
and NVL2(:P_aban,(aban8),1) in NVL(:P_aban,1)
