SQL Language (MOSC)

MOSC Banner

Convert xml/clob to readable varchar

in SQL Language (MOSC) 2 commentsAnswered ✓

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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center