Last updated on JUNE 29, 2017
Applies to:SQL*Plus - Version: 184.108.40.206
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
Million Knowledge Articles and hundreds of Community platforms