How to Remove Lines Between Rows in SQL*Plus when Using chr(10) in Select (Doc ID 334327.1)

Last updated on AUGUST 12, 2020

Applies to:

Goal

How to remove the blank line that is shown between the rows when using a SELECT statement with chr(10)?

For example:
select 'line 1 '||chr(10)||'line2' from <TABLE_NAME>;    

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.