Hi,
I have to break the concatenate string which am storing in a variable. I tried using chr(13)||chr(10) in the pl/sql code, but am unable to break it.
How can i break it
The code looks like....
my variable declaration,
FOR po_rec IN c1
LOOP
l_msg := l_msg||chr(13)||chr(10)||
po_rec.e_type
|| ' '
|| po_rec.e_name
|| ' '
|| po_rec.e_count
||chr(13)||chr(10);
END LOOP;
In this way am using the code, am able to get the output but it is continuously coming, i mean concatenating all rows into 1 row.
the output should come like this.
xxx aaaa 4
yyy bbbb 5
zzz cccc 6
but it is coming in this way,
xxx aaaa 4 yyy bbbb 5 zzz cccc 6