Chapter 3 DBMS Reference Guide


SqlListSchema

Allows to define the query used to retrieve registered schema in the database. This entry is used with tables of XML type. A table of XML type is a reference to an XML document stored in the database. When you define an XML table, you need to retrieve the XML documents registered in the database in order to assign one document to the table, this is done using the SqlListSchema query.

Example in Oracle 10g

SELECT schema_url FROM dba_xml_schemas

 


Copyright (C) 2005. Sybase Inc. All rights reserved.