I have a Oracle 9i, Release 2 (9.2) database with the follwing table:
BETA92XD> desc xs_table
Name Type NULL
---------------- -------- --------
ID NUMBER
NAME VARCHAR2(120)
FILE_TYPE VARCHAR2(4)
XML XMLTYPE
A SELECT yield that following:
BETA92XD> select * from xs_table;
ID NAME FILE TYPE
------ --------------------- ----------
1 XDB_Specification.xsd XSD
XML
-------------
XMLTYPE()
There has to be a way to get to the contents of the XMLTYPE(). What sort of function or object call is necessary to have the XML document displayed from XMLTYPE(). Cast does not seem to work for me.
BETA92XD> desc xs_table
Name Type NULL
---------------- -------- --------
ID NUMBER
NAME VARCHAR2(120)
FILE_TYPE VARCHAR2(4)
XML XMLTYPE
A SELECT yield that following:
BETA92XD> select * from xs_table;
ID NAME FILE TYPE
------ --------------------- ----------
1 XDB_Specification.xsd XSD
XML
-------------
XMLTYPE()
There has to be a way to get to the contents of the XMLTYPE(). What sort of function or object call is necessary to have the XML document displayed from XMLTYPE(). Cast does not seem to work for me.