temp table or something

[mikedaruke]

If I have 10 values I want to put in a temporary table, or somewhere where I can do an outer join real quick to see if they match, if they don't i want null.

So I have 10 values like

Peter
Bob
Christine
Mike
Jack
etc

Just want something like

Name
Peter
Bob
chistine
etc

This way I can out join and show the matches and null for none.

Make sense? I tried select peter, bob from dual, but that puts in a columns not rows.

 

[Dagon]

One option would be:

select 'peter' as colname
from dual
union all
select 'bob'
from dual
union all
...

But probably not very practical if you have a large number.