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 get Parent and Child Accounts in Oracle APPS R12

SELECT ffv1.flex_value parent_account       ,ffvt1.description parent_account_desc   ,ffv2.flex_value child_account   ,ffvt2.description...