Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Access an XML schema from Sqlplus

Status
Not open for further replies.

CRoberts

MIS
Apr 14, 1999
70
US
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top