contactination
942638Jun 16 2012 — edited Jun 16 2012I 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.