how to make the in condition be with nvl
<code>Select *
From....
full join...
where nvl(table1.id,table2.id)
in(nvl(:ids,nvl(table1.id,table2.id))
</code>
<code>Select *
From....
full join...
where nvl(table1.id,table2.id)
in(nvl(:ids,nvl(table1.id,table2.id))
</code>
Select *
From....
full join...
where nvl(table1.id,table2.id)
in(nvl(:ids,nvl(table1.id,table2.id))
This code causes an error.
Single-row subquery rerurns more that one rows
3