Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

chr(10)||chr(13)

JellyNov 29 2018 — edited Nov 30 2018

with T as(

select 'AAA' ERROR from DUAL

union all

select 'BBB' ERROR from DUAL

)

select * from T ;

I WISH SELECT RESULT

'AAA'||chr(10)||chr(13)||'BBB'

This post has been answered by mathguy on Nov 30 2018
Jump to Answer
Comments
Post Details
Added on Nov 29 2018
10 comments
1,718 views