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: 9.2.0.5 and later   [Release: 9.2 and later ]
Information in this document applies to any platform.

Symptoms

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:

T0 
T1xT2 
T3,T4,T5 

While it is required to be:

T0,T1xT2,T3,T4,T5

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms