select all vaues, including those not in row
Here is what I want to do:
SELECT x FROM tbl WHERE x in (100,200)
where there is NO '200'
with an output:
x
----------------
100
NULL
or some variation of this, such as:
x ?
_____________________
100 | 100
200 | NULL
I just don't want to have to issue separate SELECTs for each value.
Thanks
Subject
Written By
Posted
select all vaues, including those not in row
October 28, 2021 09:45AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.