SQL>
select dbms_metadata.get_xml('TABLE','DUAL') from dual;
<?xml version="1.0"?>
<ROWSET>
<ROW>
<TABLE_T>
<VERS_MAJOR>1</VERS_MAJOR>
<VERS_MINOR>0 </VERS_MINOR>
<OBJ_NUM>222</OBJ_NUM>
<SCHEMA_OBJ>
<OBJ_NUM>222</OBJ_NUM>
<DATAOBJ_NUM>222</DATAOBJ_NUM>
<OWNER_NUM>0</OWNER_NUM>
<OWNER_NAME>SYS</OWNER_NAME>
<NAME>DUAL</NAME>
<NAMESPACE>1</NAMESPACE>
<TYPE_NUM>2</TYPE_NUM>
<TYPE_NAME>TABLE</TYPE_NAME>
<CTIME>12-MAY-02</CTIME>
<MTIME>12-MAY-02</MTIME>
<STIME>12-MAY-02</STIME>
<STATUS>1</STATUS>
<FLAGS>0</FLAGS>
<SPARE1>0</SPARE1>
<SPARE2>1</SPARE2>
</SCHEMA_OBJ>
<STORAGE>
<FILE_NUM>1</FILE_NUM>
<BLOCK_NUM>1617</BLOCK_NUM>
<TYPE_NUM>5</TYPE_NUM>
<TS_NUM>0</TS_NUM>
<BLOCKS>8</BLOCKS>
<EXTENTS>1</EXTENTS>
<INIEXTS>2</INIEXTS>
<MINEXTS>1</MINEXTS>
<MAXEXTS>2147483645</MAXEXTS>
<EXTSIZE>128</EXTSIZE>
<EXTPCT>0</EXTPCT>
<USER_NUM>0</USER_NUM>
<LISTS>1</LISTS>
<GROUPS>1</GROUPS>
<BITMAPRANGES>0</BITMAPRANGES>
<CACHEHINT>0</CACHEHINT>
<SCANHINT>0</SCANHINT>
<HWMINCR>222</HWMINCR>
<FLAGS>1</FLAGS>
</STORAGE>
<TS_NAME>SYSTEM</TS_NAME>
<BLOCKSIZE>8192</BLOCKSIZE>
<DATAOBJ_NUM>222</DATAOBJ_NUM>
<COLS>1</COLS>
<PCT_FREE>10</PCT_FREE>
<PCT_USED>40</PCT_USED>
<INITRANS>1</INITRANS>
<MAXTRANS>255</MAXTRANS>
<FLAGS>1</FLAGS>
<AUDIT_VAL>--------------------------------</AUDIT_VAL>
<INTCOLS>1</INTCOLS>
<KERNELCOLS>1</KERNELCOLS>
<PROPERTY>536870912</PROPERTY>
<TRIGFLAG>0</TRIGFLAG>
<SPARE1>736</SPARE1>
<SPARE6>12-MAY-02</SPARE6>
<COL_LIST>
<COL_LIST_ITEM>
<OBJ_NUM>222</OBJ_NUM>
<COL_NUM>1</COL_NUM>
<INTCOL_NUM>1</INTCOL_NUM>
<SEGCOL_NUM>1</SEGCOL_NUM>
<PROPERTY>0</PROPERTY>
<NAME>DUMMY</NAME>
<TYPE_NUM>1</TYPE_NUM>
<LENGTH>1</LENGTH>
<CHARSETID>873</CHARSETID>
<CHARSETFORM>1</CHARSETFORM>
<SPARE1>0</SPARE1>
<SPARE2>0</SPARE2>
<SPARE3>1</SPARE3>
</COL_LIST_ITEM>
</COL_LIST>
<CON0_LIST/>
<CON1_LIST/>
<CON2_LIST/>
</TABLE_T>
</ROW>
</ROWSET>
