Home » SQL & PL/SQL » SQL & PL/SQL » Column as rows in PL/SQL Select Statement
Column as rows in PL/SQL Select Statement [message #206398] Wed, 29 November 2006 22:23 Go to next message
shyamjha
Messages: 11
Registered: September 2006
Location: Mumbai
Junior Member

I want output of below statement as column header i.e in a row
7566 7698 7782 7788 7839 7902

SQL> select distinct mgr from emp;

MGR
----------
7566
7698
7782
7788
7839
7902

Re: Column as rows in PL/SQL Select Statement [message #206427 is a reply to message #206398] Thu, 30 November 2006 00:40 Go to previous message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Search for CONCAT_ALL in this forum

Ross Leishman
Previous Topic: To_CHAR Problem
Next Topic: ORA-1300
Goto Forum:
  


Current Time: Thu Dec 08 22:01:42 CST 2016

Total time taken to generate the page: 0.10777 seconds