<div>
<div class="content wysiwyg-content">
Below is my XML, I need to read this xml using PL/SQL which is stored in oracle database as a clob object. &nbsp;I need to find out the attributes for the tags for example &lt;workordertype&gt;?<br />
<br />
&lt;?xml version=&quot;1.0&quot; encoding=&quot;UTF-8&quot; ?&gt;&lt;WORKORDER ID=&quot;16&quot; NAME=&quot;SONET Section_7 [Circuit Wizard] [Created]&quot; RESULT=&quot;CREATE&quot; &gt;&lt;WORKORDERTYPE ID=&quot;4&quot; NAME=&quot;Circuit&quot; &gt;&lt;/WORKORDERTYPE &gt;&lt;EDITWIZARD ID=&quot;1003&quot; NAME=&quot;Circuit&quot; &gt;&lt;/EDITWIZARD &gt;&lt;CIRCUIT ID=&quot;2&quot; NAME=&quot;SONET Section_7&quot; ALIAS1=&quot;&quot; ALIAS2=&quot;&quot; DESCRIPTION=&quot;&quot; FULLNAME=&quot;&quot; MARKEDFORDELETE=&quot;&quot; NOTES=&quot;&quot; OBJECTID=&quot;&quot; PROVISIONSTATUS=&quot;190000000<wbr />5&quot; PSNAME=&quot;Forecasted&quot; RELATIVENAME=&quot;&quot; SUBSTATUS=&quot;&quot; SUBTYPE=&quot;&quot; &gt;&lt;CIRCUITTYPE ID=&quot;1900000011&quot; NAME=&quot;SONET Section&quot; &gt;&lt;/CIRCUITTYPE &gt;&lt;CIRCUITDEF ID=&quot;1900000030&quot; NAME=&quot;OC-3&quot; &gt;&lt;/CIRCUITDEF &gt;&lt;/WORKORDER &gt;
</div>
</div>


Below is my XML, I need to read this xml using PL/SQL which is stored in oracle database as a clob object.  I need to find out the attributes for the tags for example <workordertype>?

<?xml version="1.0" encoding="UTF-8" ?><WORKORDER ID="16" NAME="SONET Section_7 [Circuit Wizard] [Created]" RESULT="CREATE" ><WORKORDERTYPE ID="4" NAME="Circuit" ></WORKORDERTYPE ><EDITWIZARD ID="1003" NAME="Circuit" ></EDITWIZARD ><CIRCUIT ID="2" NAME="SONET Section_7" ALIAS1="" ALIAS2="" DESCRIPTION="" FULLNAME="" MARKEDFORDELETE="" NOTES="" OBJECTID="" PROVISIONSTATUS="1900000005" PSNAME="Forecasted" RELATIVENAME="" SUBSTATUS="" SUBTYPE="" ><CIRCUITTYPE ID="1900000011" NAME="SONET Section" ></CIRCUITTYPE ><CIRCUITDEF ID="1900000030" NAME="OC-3" ></CIRCUITDEF ></WORKORDER >

parsing xml using pl/sql which is stored as clob object in database table.

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

Oracle Database

Web development can range from developing the simplest static single page of plain text to the most complex web-based internet applications, electronic businesses, and social network services using a wide variety of languages and standards, including the familiar HTML, JavaScript and jQuery, ASP and ASP.NET, PHP, ColdFusion, CSS, PHP, Flex and Flash, but also the implementation of a broad list of standards including XML, WSDL, SSDL, VoiceXML and many more.