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!

contactination

942638Jun 16 2012 — edited Jun 16 2012
I have several varchar2 value in a TYPE defined.... Now I want to take the values and show the output as a single string

i.e. TYPE REC IS TABLE OF VARCHAR2(200 CHAR) INDEX BY BINARY_INTEGER;
REC_ARRAY REC;

now values in REC_ARRAY is ("ttgggbbbjjj uuyuyy uyuyuyuy" , "jhjhjhjhjh uiuiui jhjhjhjhjh ", "jhjhjhjhj jkjkjkj kkjkjkjk ")

I want the output as ttttyyyhhhhhhhhh uuuuuu kjkjjkjkjkjkjkj
jjjjhhhhjjjjjjj kkkkii uuuuiiii jjjjjjjjjjjjjjjjjjjjjjjjj
ooioioi jjjjhhhhhhhh jjjjjjj kkkkkkkkkkkgg

i.e. each in a new line.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 14 2012
Added on Jun 16 2012
1 comment
395 views