Sql*Plus Wraps the Result into a New Line Instead of Using Column Separator
Last updated on JUNE 29, 2017
Applies to:SQL*Plus - Version: 188.8.131.52
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