Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Transpose single row into single column

913578Mar 19 2019 — edited Mar 19 2019

Hi ,

I have a query like this.

select 'a', 'b','c', 'd','e' from dual;

when i run the above it displays in a single row.

I want it to be displayed in a single column.

a

b

c

d

e

Comments
Post Details
Added on Mar 19 2019
6 comments
2,561 views