Showing posts with label CHR(10). Show all posts
Showing posts with label CHR(10). Show all posts

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.




APEX$TASK_PK

  APEX$TASK_PK is a substitution string holding the primary key value of the system of records