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!

Need help...to retrieve all collection values from a nested table column of a table.

Ora_DB_LearnerMar 17 2014 — edited Mar 17 2014
IdParameterMultiple_Values
1sev_codedataset
2regiondataset
3namedataset
IdParameterMultiple_Values
1sev_codedataset
2regiondataset
3name

dataset

wbfbc ewFWEGF

FEBG

Hi,

   Below is the table structure having Multiple_Values as collection datatype [Nested Table]

   Request you to help me, which function or mechanism i should use, so that i can show clients the all collections values with respect to its particular parameter. (in comma separated format)

Table Structure

IdParameterMultiple_Values
1sev_codedataset(This nested table column is having 3 values [12,13,14])
2regiondataset(This nested table column is having 2 values [NA,EMEA])
3namedataset(This nested table column is having 4 values [jack,bill,rik,hhh])

Expected O/P

IdParameterMultiple_Values
1sev_code12,13,14
2regionNA,EMEA
3namejack,bill,rik,hhh

Many Thanks,

Arpit

This post has been answered by Moazzam on Mar 17 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 14 2014
Added on Mar 17 2014
6 comments
788 views