Oracle UTL_FILE - multiple rows in excel for a single cell
Posted
by
user1879150
on Stack Overflow
See other posts from Stack Overflow
or by user1879150
Published on 2012-12-05T13:18:11Z
Indexed on
2012/12/05
17:04 UTC
Read the original article
Hit count: 174
I have a requirement to display the below in a csv file which is generated using UTL_FILE package of PL/SQL.
Heading1 Heading2 Heading3 ABCDE 123 987641213 xxx street yyyy
For each value in 'Heading1', I get 3 rows for address from a particular table. In the output csv file, I need to display the address in a single cell with data separated by a new line.
I tried using a cursor and appending data using chr(10), chr(12), chr(15) but in vain.
Kindly help me in getting the output.
© Stack Overflow or respective owner