1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Clob

Discussion in 'Oracle Forms and Reports' started by kalasha, Feb 21, 2017.

  1. kalasha

    kalasha Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    Location:
    Bangalore
    Hi, I am facing an issue with a column which has data's like xml tags and other special characters.

    eg:- column name - NOTE_TXT (CLOB DATATYPE)
    Which has data as below

    NOTE_TXT ( <div style="text-align: left;"><span style="background-color: rgb(255, 255, 255);color: rgb(139, 0, 139);font-style: italic;font-weight: bold;">THIS PROJECT
    RUNNING RIGHT NOW&nbsp;</span></div><p style="font-size: small;"></p>)


    I want to know how to remove those special characters and xml tags from that column. I just want to display the text which is highlighted.