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!

sql help with carriage return

AmivaMay 9 2019 — edited May 10 2019

Hi,

Need Sql query Help to get expected out put

Data in the table column Text has delimiter using </>

Actual

--------------

Text

ABC</>DEF FF</>ZZZ

How do I get 10 spaces then carriage return when there is a delimiter</>

Expected

----------------

ABC        

DEF FF        

ZZZ        

This post has been answered by Paulzip on May 9 2019
Jump to Answer
Comments
Post Details
Added on May 9 2019
8 comments
1,567 views