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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

Added on May 9 2019

8 comments

1,517 views