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!

sql query needed for this requiremnet

727350Apr 26 2010 — edited Apr 26 2010
Hi All,
I have one small requirement where i need output in format mentioned below.

I have table T

Code sql:
sql> SELECT * FROM T;

PRSID X Y Z
100 2 1 1
100 1 0 1
100 4 1 0
200 2 0 1
200 3 0 1

Now if i need output in following format is it possible!!!
100 (2,1,1),(1,0,1),(4,1,0)
200 (2,0,1),(3,0,1)

Thanks n regards
Laxman
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 24 2010
Added on Apr 26 2010
3 comments
1,191 views