When extracting data into excel file from Oracle if columns like item_description, comments or remarks, etc have multiple lines as shown in below screenshot then data will not extract properly partial data move to next line.
To overcome this issue use CHR(10) with REPLACE command as shown in below screenshot.
No comments:
Post a Comment