This discussion is archived
13 Replies Latest reply: Nov 16, 2012 4:02 AM by 973492 RSS

display multiple column values as a single column but multiple rows

973492 Newbie
Currently Being Moderated
Hi Friends,
i want to display multiple column values as a single column but multiple rows.

example:

create table temp(acct1 number,acct2 number);

insert into temp values(100,101);

insert into temp values(500,501);

i want output like this (other than union clause)

acct
-----
100
101
500
501

thanks.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points