Oracle教程 2023-02-23

Oracle 视图 ALL_XML_OUT_OF_LINE_TABLES 官方解释，作用，如何使用详细说明

ALL_XML_OUT_OF_LINE_TABLES是一个视图，它可以帮助Oracle用户查询有关将XML维护为存储在行列式格式在表中的详细信息。它显示存储XML数据的所有表，并具有自定义XML类型。ALL_XML_OUT_OF_LINE_TABLES可以通过以下查询语句查询：

SELECT *
FROM all_xml_out_of_line_tables;

该查询将返回包括表名和XML_Type字段在内的所有内容。使用此视图，可以确定存储XML数据的所有表以及表中存储的数据类型。

ALL_XML_OUT_OF_LINE_TABLES descibes all the out of line tables connected to a given root table for the same schema accessible to the current user.

Related Views

DBA_XML_OUT_OF_LINE_TABLES describes all the out of line tables connected to a given root table for the same schema in the database.
USER_XML_OUT_OF_LINE_TABLES describes all the out of line tables connected to a given root table for the same schema owned by the current user. This view does not display the TABLE_OWNER column.

Column	Datatype	Description
`SCHEMA_URL`	`VARCHAR2(700)`	The URL of the schema within which the out of line table is defined Refer to the See Also note below for links to more information about the `schemaurl` attribute for an XML schema.
`SCHEMA_OWNER`	`VARCHAR2(128)`	Owner of the schema
`TABLE_NAME`	`VARCHAR2(128)`	Name of the out of line table
`TABLE_OWNER`	`VARCHAR2(128)`	Owner of the out of line table