Convert xml/clob to readable varchar
There is a very important ( at least fo me ) view called v$sql_monitor. it has a field called binds_xml. This is xml packed into clob. Something like
<binds>
<bind name=":B1" pos="1" dty="2" dtystr="NUMBER" maxlen="22" len="6">118904234</bind>
<bind name=":B2" pos="2" dty="2" dtystr="NUMBER" maxlen="22" len="5">6452822</bind>
</binds>
I wonder how to, in most simply way, convert it to varchar or any other text format to get:
:B1 NUMBER 118904234
:B2 NUMBER 6452822
I apreciate any hints
K.