📄 refrn.htm
字号:
<td class="Informal"><a name="138563"></a><p class="TB">XML schema document </td></tr><tr class="Informal" align="LEFT" valign="TOP"><td class="Informal"><a name="138573"></a><p class="TB"><code>INT_OBJNAME</code> </td><td class="Informal"><a name="138575"></a><p class="TB"><code>VARCHAR2(4000)</code> </td><td class="Informal"><a name="138577"></a><p class="TB"> </td><td class="Informal"><a name="138579"></a><p class="TB">Internal database object name for the schema </td></tr><tr class="Informal" align="LEFT" valign="TOP"><td class="Informal"><a name="138589"></a><p class="TB"><code>QUAL_SCHEMA_URL</code> </td><td class="Informal"><a name="138591"></a><p class="TB"><code>VARCHAR2(767)</code> </td><td class="Informal"><a name="138593"></a><p class="TB"> </td><td class="Informal"><a name="138595"></a><p class="TB">Fully qualified schema URL </td></tr></table><table class="TableNote" width="100%" cellpadding="3" cellspacing="0" dir="ltr"><tr class="TableNote" align=LEFT valign=TOP><td class="TableNote"></td></tr></table></a> </ul><a name="139431"></a><!--TOC=h2-"139431"--><h3 class="H2"><font face="Arial, Helvetica, sans-serif" color="#330099"> ALL_XML_TAB_COLS</font></h3><!--/TOC=h2--><a name="1002341"></a><p class="BP"><code>ALL_XML_TAB_COLS</code> describes the columns of the XML tables accessible to the current user.</p><a name="139434"></a><!--TOC=h3-"139434"--><h4 class="H3"><font face="Arial, Helvetica, sans-serif" color="#330099"> Related Views</font></h4><!--/TOC=h3--><ul class="LB1"><li class="LB1" type="DISC"><a name="768"></a><code>DBA_XML_TAB_COLS</code> describes the columns of all XML tables in the database.<p><li class="LB1" type="DISC"><a name="770"></a><code>USER_XML_TAB_COLS</code> describes the columns of the XML tables owned by the current user. This view does not display the <code>OWNER</code> column.<p> <a name="773"><p><table class="InformalWide" border="1" frame="HSIDES" rules="GROUPS" width="100%" cellpadding="3" cellspacing="0" dir="ltr"><thead><tr class="Informal"><th class="Informal" align="left" valign="bottom" scope="col"><a name="138606"></a><font face="Arial, Helvetica, sans-serif"><strong>Column</strong></font> </th><th class="Informal" align="left" valign="bottom" scope="col"><a name="1081490"></a><font face="Arial, Helvetica, sans-serif"><strong>Datatype</strong></font> </th><th class="Informal" align="left" valign="bottom" scope="col"><a name="1081492"></a><font face="Arial, Helvetica, sans-serif"><strong>NULL</strong></font> </th><th class="Informal" align="left" valign="bottom" scope="col"><a name="1081494"></a><font face="Arial, Helvetica, sans-serif"><strong>Description</strong></font> </th></tr><tbody><tr class="Informal" align="LEFT" valign="TOP"><td class="Informal"><a name="138619"></a><p class="TB"><code>OWNER</code> </td><td class="Informal"><a name="138621"></a><p class="TB"><code>VARCHAR2(30)</code> </td><td class="Informal"><a name="138623"></a><p class="TB"> </td><td class="Informal"><a name="138625"></a><p class="TB">Owner of the XML table </td></tr><tr class="Informal" align="LEFT" valign="TOP"><td class="Informal"><a name="138635"></a><p class="TB"><code>TABLE_NAME</code> </td><td class="Informal"><a name="138637"></a><p class="TB"><code>VARCHAR2(30)</code> </td><td class="Informal"><a name="138639"></a><p class="TB"> </td><td class="Informal"><a name="138641"></a><p class="TB">Name of the XML table </td></tr><tr class="Informal" align="LEFT" valign="TOP"><td class="Informal"><a name="138651"></a><p class="TB"><code>COLUMN_NAME</code> </td><td class="Informal"><a name="138653"></a><p class="TB"><code>VARCHAR2(4000)</code> </td><td class="Informal"><a name="138655"></a><p class="TB"> </td><td class="Informal"><a name="138657"></a><p class="TB">Name of the XML table column </td></tr><tr class="Informal" align="LEFT" valign="TOP"><td class="Informal"><a name="138667"></a><p class="TB"><code>XMLSCHEMA</code> </td><td class="Informal"><a name="138669"></a><p class="TB"><code>VARCHAR2(700)</code> </td><td class="Informal"><a name="138671"></a><p class="TB"> </td><td class="Informal"><a name="138673"></a><p class="TB">Name of the XML Schema that is used for the table definition </td></tr><tr class="Informal" align="LEFT" valign="TOP"><td class="Informal"><a name="138683"></a><p class="TB"><code>SCHEMA_OWNER</code> </td><td class="Informal"><a name="138685"></a><p class="TB"><code>VARCHAR2(30)</code> </td><td class="Informal"><a name="138687"></a><p class="TB"> </td><td class="Informal"><a name="138689"></a><p class="TB">Owner of the XML Schema that is used for the table definition </td></tr><tr class="Informal" align="LEFT" valign="TOP"><td class="Informal"><a name="138699"></a><p class="TB"><code>ELEMENT_NAME</code> </td><td class="Informal"><a name="138701"></a><p class="TB"><code>VARCHAR2(256)</code> </td><td class="Informal"><a name="138703"></a><p class="TB"> </td><td class="Informal"><a name="138705"></a><p class="TB">Name of the XML Schema element that is used for the table </td></tr><tr class="Informal" align="LEFT" valign="TOP"><td class="Informal"><a name="138715"></a><p class="TB"><code>STORAGE_TYPE</code> </td><td class="Informal"><a name="138717"></a><p class="TB"><code>VARCHAR2(17)</code> </td><td class="Informal"><a name="138719"></a><p class="TB"> </td><td class="Informal"><a name="138721"></a><p class="TB">Storage option for the XMLType data (<code>OBJECT-RELATIONAL</code> or <code>CLOB</code>) </td></tr></table><table class="TableNote" width="100%" cellpadding="3" cellspacing="0" dir="ltr"><tr class="TableNote" align=LEFT valign=TOP><td class="TableNote"></td></tr></table></a> </ul><a name="139440"></a><!--TOC=h2-"139440"--><h3 class="H2"><font face="Arial, Helvetica, sans-serif" color="#330099"> ALL_XML_TABLES</font></h3><!--/TOC=h2--><a name="1002341"></a><p class="BP"><code>ALL_XML_TABLES</code> describes the XML tables accessible to the current user.</p><a name="139443"></a><!--TOC=h3-"139443"--><h4 class="H3"><font face="Arial, Helvetica, sans-serif" color="#330099"> Related Views</font></h4><!--/TOC=h3--><ul class="LB1"><li class="LB1" type="DISC"><a name="768"></a><code>DBA_XML_TABLES</code> describes all XML tables in the database.<p><li class="LB1" type="DISC"><a name="770"></a><code>USER_XML_TABLES</code> describes the XML tables owned by the current user. This view does not display the <code>OWNER</code> column.<p> <a name="773"><p><table class="InformalWide" border="1" frame="HSIDES" rules="GROUPS" width="100%" cellpadding="3" cellspacing="0" dir="ltr"><thead><tr class="Informal"><th class="Informal" align="left" valign="bottom" scope="col"><a name="138732"></a><font face="Arial, Helvetica, sans-serif"><strong>Column</strong></font> </th><th class="Informal" align="left" valign="bottom" scope="col"><a name="1081490"></a><font face="Arial, Helvetica, sans-serif"><strong>Datatype</strong></font> </th><th class="Informal" align="left" valign="bottom" scope="col"><a name="1081492"></a><font face="Arial, Helvetica, sans-serif"><strong>NULL</strong></font> </th><th class="Informal" align="left" valign="bottom" scope="col"><a name="1081494"></a><font face="Arial, Helvetica, sans-serif"><strong>Description</strong></font> </th></tr><tbody><tr class="Informal" align="LEFT" valign="TOP"><td class="Informal"><a name="138745"></a><p class="TB"><code>OWNER</code> </td><td class="Informal"><a name="138747"></a><p class="TB"><code>VARCHAR2(30)</code> </td><td class="Informal"><a name="138749"></a><p class="TB"> </td><td class="Informal"><a name="138751"></a><p class="TB">Owner of the XML table </td></tr><tr class="Informal" align="LEFT" valign="TOP"><td class="Informal"><a name="138761"></a><p class="TB"><code>TABLE_NAME</code> </td><td class="Informal"><a name="138763"></a><p class="TB"><code>VARCHAR2(30)</code> </td><td class="Informal"><a name="138765"></a><p class="TB"> </td><td class="Informal"><a name="138767"></a><p class="TB">Name of the XML table </td></tr><tr class="Informal" align="LEFT" valign="TOP"><td class="Informal"><a name="138777"></a><p class="TB"><code>XMLSCHEMA</code> </td><td class="Informal"><a name="138779"></a><p class="TB"><code>VARCHAR2(700)</code> </td><td class="Informal"><a name="138781"></a><p class="TB"> </td><td class="Informal"><a name="138783"></a><p class="TB">Name of the XML Schema that is used for the table definition </td></tr><tr class="Informal" align="LEFT" valign="TOP"><td class="Informal"><a name="138793"></a><p class="TB"><code>SCHEMA_OWNER</code> </td><td class="Informal"><a name="138795"></a><p class="TB"><code>VARCHAR2(30)</code> </td><td class="Informal"><a name="138797"></a><p class="TB"> </td><td class="Informal"><a name="138799"></a><p class="TB">Owner of the XML Schema that is used for the table definition </td></tr><tr class="Informal" align="LEFT" valign="TOP"><td class="Informal"><a name="138809"></a><p class="TB"><code>ELEMENT_NAME</code> </td><td class="Informal"><a name="138811"></a><p class="TB"><code>VARCHAR2(256)</code> </td><td class="Informal"><a name="138813"></a><p class="TB"> </td><td class="Informal"><a name="138815"></a><p class="TB">Name of the XML Schema element that is used for the table </td></tr><tr class="Informal" align="LEFT" valign="TOP"><td class="Informal"><a name="138825"></a><p class="TB"><code>STORAGE_TYPE</code> </td><td class="Informal"><a name="138827"></a><p class="TB"><code>VARCHAR2(17)</code> </td><td class="Informal"><a name="138829"></a><p class="TB"> </td><td class="Informal"><a name="138831"></a><p class="TB">Storage option for the XMLType data (<code>OBJECT-RELATIONAL</code> or <code>CLOB</code>) </td></tr></table><table class="TableNote" width="100%" cellpadding="3" cellspacing="0" dir="ltr"><tr class="TableNote" align=LEFT valign=TOP><td class="TableNote"></td></tr></table></a> </ul><a name="139449"></a><!--TOC=h2-"139449"--><h3 class="H2"><font face="Arial, Helvetica, sans-serif" color="#330099"> ALL_XML_VIEW_COLS</font></h3><!--/TOC=h2--><a name="1002341"></a><p class="BP"><code>ALL_XML_VIEW_COLS</code> describes the columns of the XML views accessible to the current user.</p><a name="139452"></a><!--TOC=h3-"139452"--><h4 class="H3"><font face="Arial, Helvetica, sans-serif" color="#330099"> Related Views</font></h4><!--/TOC=h3--><ul class="LB1"><li class="LB1" type="DISC"><a name="768"></a><code>DBA_XML_VIEW_COLS</code> describes the columns of all XML views in the database.<p><li class="LB1" type="DISC"><a name="770"></a><code>USER_XML_VIEW_COLS</code> describes the columns of the XML views owned by the current user. This view does not display the <code>OWNER</code> column.<p> <a name="773"><p><table class="InformalWide" border="1" frame="HSIDES" rules="GROUPS" width="100%" cellpadding="3" cellspacing="0" dir="ltr"><thead><tr class="Informal"><th class="Informal" align="left" valign="bottom" scope="col"><a name="138842"></a><font face="Arial, Helvetica, sans-serif"><strong>Column</strong></font> </th><th class="Informal" align="left" valign="bottom" scope="col"><a name="1081490"></a><font face="Arial, Helvetica, sans-serif"><strong>Datatype</strong></font> </th><th class="Informal" align="left" valign="bottom" scope="col"><a name="1081492"></a><font face="Arial, Helvetica, sans-serif"><strong>NULL</strong></font> </th><th class="Informal" align="left" valign="bottom" scope="col"><a name="1081494"></a><font face="Arial, Helvetica, sans-serif"><strong>Description</strong></font> </th></tr><tbody><tr class="Informal" align="LEFT" valign="TOP"><td class="Informal"><a name="138855"></a><p class="TB"><code>OWNER</code> </td><td class="Informal"><a name="138857"></a><p class="TB"><code>VARCHAR2(30)</code> </td><td class="Informal"><a name="138859"></a><p class="TB"> </td><td class="Informal"><a name="138861"></a><p class="TB">Owner of the XML view </td></tr><tr class="Informal" align="LEFT" valign="TOP"><td class="Informal"><a name="138871"></a><p class="TB"><code>VIEW_NAME</code> </td><td class="Informal"><a name="138873"></a><p class="TB"><code>VARCHAR2(30)</code> </td><td class="Informal"><a name="138875"></a><p class="TB"> </td><td class="Informal"><a name="138877"></a><p class="TB">Name of the XML view </td></tr><tr class="Informal" align="LEFT" valign="TOP"><td class="Informal"><a name="138887"></a><p class="TB"><code>COLUMN_NAME</code> </td><td class="Informal"><a name="138889"></a><p class="TB"><code>VARCHAR2(4000)</code> </td><td class="Informal"><a name="138891"></a><p class="TB"> </td><td class="Informal"><a name="138893"></a><p class="TB">Name of the XML view column </td></tr><tr class="Informal" align="LEFT" valign="TOP"><td class="Informal"><a name="138903"></a><p class="TB"><code>XMLSCHEMA</code> </td><td class="Informal"><a name="138905"></a><p class="TB"><code>VARCHAR2(700)</code> </td><td class="Informal"><a name="138907"></a><p class="TB"> </td><td class="Informal"><a name="138909"></a><p class="TB">Name of the XML Schema that is used for the view definition </td></tr><tr class="Informal" align="LEFT" valign="TOP"><td class="Informal"><a name="138919"></a><p class="TB"><code>SCHEMA_OWNER</code> </td><td class="Informal"><a name="138921"></a><p class="TB"><code>VARCHAR2(30)</code> </td><td class="Informal"><a name="138923"></a><p class="TB"> </td><td class="Informal"><a name="138925"></a><p class="TB">Owner of the XML Schema that is used for the view definition </td></tr><tr class="Informal" align="LEFT" valign="TOP"><td class="Informal"><a name="138935"></a><p class="TB"><code>ELEMENT_NAME</code> </td><td class="Informal"><a name="138937"></a><p class="TB"><code>VARCHAR2(256)</code> </td><td class="Informal"><a name="138939"></a><p class="TB"> </td><td class="Informal"><a name="138941"></a><p class="TB">Name of the XML Schema element that is used for the view </td></tr></table>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -