My Oracle Support Banner

Sql*Plus Wraps the Result into a New Line Instead of Using Column Separator (Doc ID 754105.1)

Last updated on JUNE 29, 2017

Applies to:

SQL*Plus - Version: and later   [Release: 9.2 and later ]
Information in this document applies to any platform.


Colsep is set.

Set colsep ',' ;  

Query includes a function returning varchar2 as concatenation.

Values after the function is wrapped in the result.

i.e. Running the following query

SQL> select 'T0','T1'||RETRN('x')||'T2','T3','T4','T5' from dual;

where RETRN function is returning varchar2 = 'x'

Then the output will be:


While it is required to be:



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.