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:



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