Hi,
Can any one explain how below statement is executing.
Select * from table A
where
INVOICE_ID IN (DECODE(:P_INVOICE_ID,NULL,INVOICE_ID,:P_INVOICE_ID))
if i try to pass multiple values to :P_INVOICE_ID, its not working as expected.
i,e,. it is not considering the all parameter values.
Please see the attachment.
Many thanks