how to make the in condition be with nvl
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
Oracle SQL when in nvl [closed]
Oracle SQL when in nvl [closed]
how to make the in condition be with nvl
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