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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

Processing
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,154 views