Tuesday, October 19, 2021

Issue with Description/Comment/Remark columns in Oracle(when column has value in multiple lines)

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.


 Now result showing in one line only.




No comments:

Post a Comment

Query To Fetch AP Invoice Details From SO Number(Doc ID 2949013.1)

SELECT dh.source_order_number       ,df.source_line_number as so_line_number   ,df.fulfill_line_number    ,ddr.doc_user_key as po_number...