Skip to Main Content
Forums

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!

How can I convert XML formatted text to plain text?

johnnie.billingsJul 8 2015 — edited Jul 8 2015

Oracle 11gr2: 11.2.0.4.0

I have data that is parsed from XML and saved in a table as a VARCHAR field. 

The text is formatted like this:

<span style="font-family:'Times New Roman','serif'; font-size:12pt">24 PC'S "6 x 4up arrays" =  MAX FOR MIN QTY AT INDICATED LOT CHARGE </span><br> Material currently in stock


I need to remove the formatting and convert the text to this: 

24 PC'S 6 x 4up arrays MAX FOR MIN QTY AT INDICATED LOT CHARGE Material currently in stock


Is there an existing function in SQL or PL/SQL that will decode the formatting?

Thanks,

-- Johnnie
This post has been answered by odie_63 on Jul 8 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 5 2015
Added on Jul 8 2015
1 comment
1,361 views