SQL & PL/SQL

Hello Team,

We are using oracle 12c,trying to retrieve data from clob column in a specific format. clob column has data stored in xml format.Table structure is given below.

<?xml version="1.0" encoding="UTF-8"?>

<references version="15.0">

    <reference name="CheckProperties" lsd="14-Jun-2017 10:58:55">

      <context name="ABC">

        <value>procedure_id</value>

        <value>procedure_name</value>

        <value>compiled_date</value>

       </context>

    </reference>

  <reference name="user_default values.System" lsd="14-Jun-2017 10:58:55">

      <context name="ABC">

        <value>CDE</value>

      </context>

    </reference>

    <reference name="user_default values.Source" lsd="14-Jun-2017 11:35:42">

      <context name="ABC">

        <value>Automated</value>

      </context>

    </reference>

    <reference name="user_default values.Unit" lsd="14-Jun-2017 11:35:41">

      <context name="ABC">

        <value>cm2</value>

      </context>

    </reference>

    <reference name="user_default values.Title" lsd="14-Jun-2017 11:35:43">

      <context name="ABC">

        <value>Tanay</value>

      </context>

    </reference>

</references>

Above xml data is stored into xml_data_column having clob data type. And I am trying to get output in below format.

reference name and value will be retrieved from clob column and displayed with reference and value with different columns as shown below.

Expected o/p :

Could you please suggest any sql or plsql code for the above. I have tried but not getting expected o/p.

Thanks in Advance.