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: 18.104.22.168
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