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!

Do we have any equivalent UNESCAPE_REFERENCE function in DBMS_LOB to remove HTML Tags for 12c DB ?

User_YVQHSJul 5 2021

We used function UTL_I18N.UNESCAPE_REFERENCE to remove HTML Tags. But this works for String Len 2000.
Is there any function that will comply with NCLOB Data to remove HTML Tags (or) Do we have any equivalent UNESCAPE_REFERENCE function in DBMS_LOB to remove HTML Tags for 12c DB?

This post has been answered by Paulzip on Jul 5 2021

Jump to Answer

Added on Jul 5 2021

1 comment

588 views