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

Filed under:
|
|
|

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

Related posts about Oracle

Related posts about csv