hi how can i ignore null values,my use case is i have value which i beign pass by user from java application some value the user pass return null in database how can i ignore those null value but still return value which got value even if use is sending value which got null
my query is
select max(sub_category_date_active), max( SUB_CATEGORY_DATE_INACTIVE) from sub_category
where SUB_CATEGORY_CAT_CODE = '104'
and SUB_CATEGORY_CODE = '10'
and SUB_CATEGORY_FLOW = 'OUT'
and SUB_CATEGORY_BOP_VERSION = '3'
AND SUB_CATEGORY_DATE_INACTIVE IS NOT NULL
the value in my query return null but i don't what to return value if there is null,i don't have control of the value what the use is sending
you can also follow this discussion
calling oracle sql with a not null where cluee in java