13 Replies Latest reply: Nov 16, 2012 6:02 AM by 973492 RSS

    display multiple column values as a single column but multiple rows

    973492
      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.