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!

Multiple columns to Multiple rows

MM2587Feb 19 2019 — edited Feb 20 2019

Hi want to convert a row with multiple columns into 2 columns with multiple rows.

For example: consider select * from emp where empno = 7788 which gives the following output

emp.JPG

I am trying to display the above data as in below image.

vertical.JPG

Is it possible that we can vertically display the data instead of horizontally?

Comments
Post Details
Added on Feb 19 2019
16 comments
2,072 views