Skip to Main Content
Forums

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!

Urgent SQL question : how to flip vertical row values to horizontal ?

360862Aug 31 2004 — edited Sep 2 2004
Hello, Oracle people !

I have an urgent SQL question : (simple for you)
using SELECT statement, how to convert vertical row values to horizontal ?

For example :

(Given result-set)
----------------------------------
MANAGER COLUMN1 COLUMN2 COLUMN3
----------------------------------
K. Smith ......1
K. Smith ...............1
K. Smith ........................1


(Needed result-set)
----------------------------------
MANAGER COLUMN1 COLUMN2 COLUMN3
----------------------------------
K. Smith ......1 .......1 .......1

I know you can, just don't remeber how and can't find exactly answer I'm looking for. Probably using some analytic SQL function (CAST OVER, PARTITION BY, etc.)

Please Help !!!
Thanx !
Steve.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 30 2004
Added on Aug 31 2004
16 comments
802 views