Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to get element/attribute value from XML stored as CLOB

583611Aug 23 2007 — edited Oct 29 2007

Hi
I just want to get the value of an attribute stored in xmlformat within a CLOB column.

Its a 1 off query - not worried about perforamance
I thought it would be something similar to this - but haven't worked it out
Can someone shed some light ?

thanks

select extractValue(text, 'ORACLE_HOME')
from
(SELECT XMLElement(FND_OAM_CONTEXT_FILES,TEXT) from APPLSYS.FND_OAM_CONTEXT_FILES where NAME='VIS_lucas')
where existsNode(text,'ORACLE_HOME')=1

The table FND_OAM_CONTEXT_FILES has a column TEXT of type CLOB which contains loaded XML data (unstrcutured)

??

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 26 2007

Added on Aug 23 2007

#performance-availability, #xml-db

10 comments

4,006 views