My Oracle Support Banner

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 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)?

For example:
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

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