Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

with tbl as
(
    select xmltype('<html><body><table class="table table-striped " border=''1''>
 <caption>ACO Details</caption>
 <tr><th><b>Record</b></th><th><b>Changed ACO(s)</b></th></tr>
 <tr><td> Added   ACO</td><td>TDE</td></tr></table>
 <br />
 <table style=''width:60%;'' border=''1''>
 <caption>Price Breakdown</caption>
 <tr style=''background-color: darkgray;text-align:right;''>
 <th style=''width:50%;text-align: center;''><b>Price</b></th>
 <th style=''width:30%;text-align: center;''><b>Difference</b></th></tr>
 <tr><td> Base Price</td><td style=''text-align:right;''>0.00</td></tr>
 <tr><td> Extras Price</td><td style=''text-align:right;''>43.98</td></tr>
 <tr><td> Total Discount</td><td style=''text-align:right;''>0.00</td></tr>
 <tr><td> Medical Price</td><td style=''text-align:right;''>0.00</td></tr>
 <tr><td> Postage</td><td style=''text-align:right;''>0.00</td></tr>
 <tr><td> Admin Fee</td><td style=''text-align:right;''>0.00</td></tr>
 <tr><td> Transaction Fee</td><td style=''text-align:right;''>0.00</td></tr>
 <tr><td> Auto Renewal Adjustment</td><td style=''text-align:right;''>0.00</td></tr>
 <tr><td> Stamp Duty</td><td style=''text-align:right;''>0.00</td></tr>
 <tr><td> Competitor Price Matching Discount</td><td style=''text-align:right;''>0.00</td></tr>
 <tr><td> Charge Adjustment</td><td style=''text-align:right;''>0.00</td></tr>
 <tr><td> Total Price</td><td style=''text-align:right;''>43.98</td></tr></table>
 <br/>
 <table style=''width:60%;'' border=''1''>
 <caption>Reason</caption><tr><td>Change Done in Web</td></tr>
 </table>
 <br/></body></html>') xml_data from dual
)
SELECT x.class,
       x.caption
FROM   tbl
       CROSS JOIN
       XMLTABLE(
         '/html/body/table'
         PASSING tbl.xml_data
         COLUMNS
            class   VARCHAR2(50) PATH './@class',
            caption VARCHAR2(30) PATH './caption/text()'
       ) x;

CLASS	CAPTION
table table-striped	ACO Details
null	Price Breakdown
null	Reason