select two rows from dual?

ok this seems easy enough, but i havent been able to find a solution.

i want to make a query from the DUAL table that returns two rows of data like this:

DUAL
-----
N
Y


i know that "select 'N' from dual" can give you 1 row, but i want both. and no, i do not want to create a dummy table. i want this to all be on the fly.

dougtimmsAsked:
Who is Participating?
 
sidcapConnect With a Mentor Commented:
why don't you try using "union" ?

select 'N' from dual union select 'N' from dual

SIDCAP.
0
 
jammalkCommented:
U can try this too..!
SQL> select 'Y'||chr(10)||'N' from dual;

'Y'
---
Y
N

Whats the purpose of this.... ?
0
 
dougtimmsAuthor Commented:
Thanks a lot...exactly the answer i was looking for.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.