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:SQL*Plus - Version 22.214.171.124 and later
Information in this document applies to any platform.
How to remove the blank line that is shown between the rows when using a SELECT statement with chr(10)?
select 'line 1 '||chr(10)||'line2' from <TABLE_NAME>;
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document