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!

Extract a specific value from a CLOB field and process that value in Oracle.

Shiva509Dec 31 2019 — edited Jan 7 2020

Below is the piece of clob data.

<?xml version="1.0" encoding="windows-1252"?>

<XMI xmi.version="1.1" xmlns:UML="omg.org/UML1.3" timestamp="2019-12-27 05:30:16">

<XMI.header>

<XMI.documentation>

<XMI.exporter>Enterprise Architect</XMI.exporter>

<XMI.exporterVersion>2.5</XMI.exporterVersion>

        </XMI.documentation>

</XMI.header>

    <XMI.content>

<UML:Model name="EA Model" xmi.id="01912248_FDE35517">

<UML:Namespace.ownedElement>

<UML:Class name="EARootClass" xmi.id="11111111_A7F4_CB0AA00" isRoot="true" isLeaf="false" isAbstract="false"/>

</UML:Namespace.ownedElement>

        </UML:Model>

    </XMI.content>

</XMI>

Need to extract attribute name from UML Class i.e "EARootClass" and process these value using a another table(Assume that there is a table that contains abbreviation of the words).

My final output would be like

<?xml version="1.0" encoding="windows-1252"?>

<XMI xmi.version="1.1" xmlns:UML="omg.org/UML1.3" timestamp="2019-12-27 05:30:16">

<XMI.header>

<XMI.documentation>

<XMI.exporter>Enterprise Architect</XMI.exporter>

<XMI.exporterVersion>2.5</XMI.exporterVersion>

        </XMI.documentation>

</XMI.header>

    <XMI.content>

<UML:Model name="EA Model" xmi.id="01912248_FDE35517">

<UML:Namespace.ownedElement>

<UML:Class name="EA_RT_CLS" xmi.id="11111111_A7F4_CB0AA00" isRoot="true" isLeaf="false" isAbstract="false"/>

</UML:Namespace.ownedElement>

        </UML:Model>

    </XMI.content>

</XMI>

Thanks in advance,

Shiva
This post has been answered by Paulzip on Jan 5 2020
Jump to Answer

Comments

Post Details

Added on Dec 31 2019
#plsql, #xml
10 comments
2,068 views