select YES, NO, NULL from a column

select YES, NO, NULL from a column:

decode(decode(:SCAN,'%','%',nvl(detail_schema.SCAN,'NULL')),:SCAN,1)=1