myscripts: 2017

SQL> select dbms_metadata.get_xml('TABLE','EMP','SCOTT') from dual;

<?xml version="1.0"?><ROWSET><ROW>
<TABLE_T>
<VERS_MAJOR>2</VERS_MAJOR>
<VERS_MINOR>5 </VERS_MINOR>
<OBJ_NUM>20056</OBJ_NUM>
<SCHEMA_OBJ>
<OBJ_NUM>20056</OBJ_NUM>
<DATAOBJ_NUM>20056</DATAOBJ_NUM>
<OWNER_NUM>48</OWNER_NUM>
<OWNER_NAME>SCOTT</OWNER_NAME>
<NAME>EMP</NAME>
<NAMESPACE>1</NAMESPACE>
<TYPE_NUM>2</TYPE_NUM>
<TYPE_NAME>TABLE</TYPE_NAME>
<CTIME>2016-11-29 16:22:24</CTIME>
<MTIME>2017-01-05 17:33:32</MTIME>
<STIME>2016-12-09 16:30:57</STIME>
<STATUS>1</STATUS>
<FLAGS>0</FLAGS>
<SPARE1>6</SPARE1>
<SPARE2>15</SPARE2>
<SPARE3>48</SPARE3>
<OWNER_NAME2>SCOTT</OWNER_NAME2>
</SCHEMA_OBJ>
<STORAGE>
<FILE_NUM>1</FILE_NUM>
<BLOCK_NUM>44984</BLOCK_NUM>
<TYPE_NUM>5</TYPE_NUM>
<TS_NUM>0</TS_NUM>
<BLOCKS>8</BLOCKS>
<EXTENTS>1</EXTENTS>
<INIEXTS>8</INIEXTS>
<MINEXTS>1</MINEXTS>
<MAXEXTS>2147483645</MAXEXTS>
<EXTSIZE>128</EXTSIZE>
<EXTPCT>0</EXTPCT>
<USER_NUM>48</USER_NUM>
<LISTS>1</LISTS>
<GROUPS>1</GROUPS>
<BITMAPRANGES>2147483645</BITMAPRANGES>
<CACHEHINT>0</CACHEHINT>
<SCANHINT>0</SCANHINT>
<HWMINCR>20056</HWMINCR>
<FLAGS>4325377</FLAGS>
</STORAGE>
<TS_NAME>SYSTEM</TS_NAME>
<BLOCKSIZE>8192</BLOCKSIZE>
<DATAOBJ_NUM>20056</DATAOBJ_NUM>
<COLS>8</COLS>
<PCT_FREE>10</PCT_FREE>
<PCT_USED>40</PCT_USED>
<INITRANS>1</INITRANS>
<MAXTRANS>255</MAXTRANS>
<FLAGS>1074266129</FLAGS>
<AUDIT_VAL>--------------------------------------</AUDIT_VAL>
<ROWCNT>14</ROWCNT>
<BLKCNT>1</BLKCNT>
<EMPCNT>6</EMPCNT>
<AVGSPC>7422</AVGSPC>
<CHNCNT>0</CHNCNT>
<AVGRLN>41</AVGRLN>
<AVGSPC_FLB>7422</AVGSPC_FLB>
<FLBCNT>1</FLBCNT>
<ANALYZETIME>2017/01/04 14:39:07</ANALYZETIME>
<SAMPLESIZE>14</SAMPLESIZE>
<INTCOLS>8</INTCOLS>
<KERNELCOLS>8</KERNELCOLS>
<PROPERTY>537919488</PROPERTY>
<PROPERTY2>0</PROPERTY2>
<XMLSCHEMACOLS>N</XMLSCHEMACOLS>
<TSTZ_COLS>N</TSTZ_COLS>
<TRIGFLAG>0</TRIGFLAG>
<SPARE1>736</SPARE1>
<SPARE3>1225763</SPARE3>
<SPARE5>NN0</SPARE5>
<SPARE6>2016/12/09 11:00:57</SPARE6>
<COL_LIST>
<COL_LIST_ITEM>
<OBJ_NUM>20056</OBJ_NUM>
<COL_NUM>1</COL_NUM>
<SEGCOL_NUM>1</SEGCOL_NUM>
<SEGCOLLENGTH>22</SEGCOLLENGTH>
<OFFSET>0</OFFSET>
<NAME>EMPNO</NAME>
<TYPE_NUM>2</TYPE_NUM>
<LENGTH>22</LENGTH>
<FIXEDSTORAGE>0</FIXEDSTORAGE>
<PRECISION_NUM>4</PRECISION_NUM>
<SCALE>0</SCALE>
<NOT_NULL>1</NOT_NULL>
<INTCOL_NUM>1</INTCOL_NUM>
<BASE_INTCOL_NUM>1</BASE_INTCOL_NUM>
<BASE_COL_TYPE>0</BASE_COL_TYPE>
<PROPERTY>0</PROPERTY>
<CHARSETID>0</CHARSETID>
<CHARSETFORM>0</CHARSETFORM>
<CON>
<OWNER_NUM>48</OWNER_NUM>
<NAME>SYS_C006988</NAME>

<CON_NUM>6988</CON_NUM>
<OBJ_NUM>20056</OBJ_NUM>
<NUMCOLS>1</NUMCOLS>
<CONTYPE>7</CONTYPE>
<ENABLED>1</ENABLED>
<INTCOLS>1</INTCOLS>
<MTIME>2016/11/29 16:22:24</MTIME>
<FLAGS>12</FLAGS>
</CON>
<SPARE1>0</SPARE1>
<SPARE2>0</SPARE2>
<SPARE3>0</SPARE3>
</COL_LIST_ITEM>
<COL_LIST_ITEM>
<OBJ_NUM>20056</OBJ_NUM>
<COL_NUM>2</COL_NUM>
<SEGCOL_NUM>2</SEGCOL_NUM>
<SEGCOLLENGTH>10</SEGCOLLENGTH>
<OFFSET>0</OFFSET>
<NAME>ENAME</NAME>
<TYPE_NUM>1</TYPE_NUM>
<LENGTH>10</LENGTH>
<FIXEDSTORAGE>0</FIXEDSTORAGE>
<NOT_NULL>0</NOT_NULL>
<INTCOL_NUM>2</INTCOL_NUM>
<BASE_INTCOL_NUM>2</BASE_INTCOL_NUM>
<BASE_COL_TYPE>0</BASE_COL_TYPE>
<PROPERTY>0</PROPERTY>
<CHARSETID>873</CHARSETID>
<CHARSETFORM>1</CHARSETFORM>
<SPARE1>0</SPARE1>
<SPARE2>0</SPARE2>
<SPARE3>10</SPARE3>
</COL_LIST_ITEM>
<COL_LIST_ITEM>
<OBJ_NUM>20056</OBJ_NUM>
<COL_NUM>3</COL_NUM>
<SEGCOL_NUM>3</SEGCOL_NUM>
<SEGCOLLENGTH>9</SEGCOLLENGTH>
<OFFSET>0</OFFSET>
<NAME>JOB</NAME>
<TYPE_NUM>1</TYPE_NUM>
<LENGTH>9</LENGTH>
<FIXEDSTORAGE>0</FIXEDSTORAGE>
<NOT_NULL>0</NOT_NULL>
<INTCOL_NUM>3</INTCOL_NUM>
<BASE_INTCOL_NUM>3</BASE_INTCOL_NUM>
<BASE_COL_TYPE>0</BASE_COL_TYPE>
<PROPERTY>0</PROPERTY>
<CHARSETID>873</CHARSETID>
<CHARSETFORM>1</CHARSETFORM>
<SPARE1>0</SPARE1>
<SPARE2>0</SPARE2>
<SPARE3>9</SPARE3>
</COL_LIST_ITEM>
<COL_LIST_ITEM>
<OBJ_NUM>20056</OBJ_NUM>
<COL_NUM>4</COL_NUM>
<SEGCOL_NUM>4</SEGCOL_NUM>
<SEGCOLLENGTH>22</SEGCOLLENGTH>
<OFFSET>0</OFFSET>
<NAME>MGR</NAME>
<TYPE_NUM>2</TYPE_NUM>
<LENGTH>22</LENGTH>
<FIXEDSTORAGE>0</FIXEDSTORAGE>
<PRECISION_NUM>4</PRECISION_NUM>
<SCALE>0</SCALE>
<NOT_NULL>0</NOT_NULL>
<INTCOL_NUM>4</INTCOL_NUM>
<BASE_INTCOL_NUM>4</BASE_INTCOL_NUM>
<BASE_COL_TYPE>0</BASE_COL_TYPE>
<PROPERTY>0</PROPERTY>
<CHARSETID>0</CHARSETID>
<CHARSETFORM>0</CHARSETFORM>
<SPARE1>0</SPARE1>
<SPARE2>0</SPARE2>
<SPARE3>0</SPARE3>
</COL_LIST_ITEM>
<COL_LIST_ITEM>
<OBJ_NUM>20056</OBJ_NUM>
<COL_NUM>5</COL_NUM>
<SEGCOL_NUM>5</SEGCOL_NUM>
<SEGCOLLENGTH>7</SEGCOLLENGTH>
<OFFSET>0</OFFSET>
<NAME>HIREDATE</NAME>
<TYPE_NUM>12</TYPE_NUM>
<LENGTH>7</LENGTH>
<FIXEDSTORAGE>0</FIXEDSTORAGE>
<NOT_NULL>0</NOT_NULL>
<INTCOL_NUM>5</INTCOL_NUM>
<BASE_INTCOL_NUM>5</BASE_INTCOL_NUM>
<BASE_COL_TYPE>0</BASE_COL_TYPE>
<PROPERTY>0</PROPERTY>
<CHARSETID>0</CHARSETID>
<CHARSETFORM>0</CHARSETFORM>
<SPARE1>0</SPARE1>
<SPARE2>0</SPARE2>
<SPARE3>0</SPARE3>
</COL_LIST_ITEM>

<COL_LIST_ITEM>
<OBJ_NUM>20056</OBJ_NUM>
<COL_NUM>6</COL_NUM>
<SEGCOL_NUM>6</SEGCOL_NUM>
<SEGCOLLENGTH>22</SEGCOLLENGTH>
<OFFSET>0</OFFSET>
<NAME>SAL</NAME>
<TYPE_NUM>2</TYPE_NUM>
<LENGTH>22</LENGTH>
<FIXEDSTORAGE>0</FIXEDSTORAGE>
<PRECISION_NUM>7</PRECISION_NUM>
<SCALE>2</SCALE>
<NOT_NULL>0</NOT_NULL>
<INTCOL_NUM>6</INTCOL_NUM>
<BASE_INTCOL_NUM>6</BASE_INTCOL_NUM>
<BASE_COL_TYPE>0</BASE_COL_TYPE>
<PROPERTY>0</PROPERTY>
<CHARSETID>0</CHARSETID>
<CHARSETFORM>0</CHARSETFORM>
<SPARE1>0</SPARE1>
<SPARE2>0</SPARE2>
<SPARE3>0</SPARE3>
</COL_LIST_ITEM>
<COL_LIST_ITEM>
<OBJ_NUM>20056</OBJ_NUM>
<COL_NUM>7</COL_NUM>
<SEGCOL_NUM>7</SEGCOL_NUM>
<SEGCOLLENGTH>22</SEGCOLLENGTH>
<OFFSET>0</OFFSET>
<NAME>COMM</NAME>
<TYPE_NUM>2</TYPE_NUM>
<LENGTH>22</LENGTH>
<FIXEDSTORAGE>0</FIXEDSTORAGE>
<PRECISION_NUM>7</PRECISION_NUM>
<SCALE>2</SCALE>
<NOT_NULL>0</NOT_NULL>
<INTCOL_NUM>7</INTCOL_NUM>
<BASE_INTCOL_NUM>7</BASE_INTCOL_NUM>
<BASE_COL_TYPE>0</BASE_COL_TYPE>
<PROPERTY>0</PROPERTY>
<CHARSETID>0</CHARSETID>
<CHARSETFORM>0</CHARSETFORM>
<SPARE1>0</SPARE1>
<SPARE2>0</SPARE2>
<SPARE3>0</SPARE3>
</COL_LIST_ITEM>
<COL_LIST_ITEM>
<OBJ_NUM>20056</OBJ_NUM>
<COL_NUM>8</COL_NUM>
<SEGCOL_NUM>8</SEGCOL_NUM>
<SEGCOLLENGTH>22</SEGCOLLENGTH>
<OFFSET>0</OFFSET>
<NAME>DEPTNO</NAME>
<TYPE_NUM>2</TYPE_NUM>
<LENGTH>22</LENGTH>
<FIXEDSTORAGE>0</FIXEDSTORAGE>
<PRECISION_NUM>2</PRECISION_NUM>
<SCALE>0</SCALE>
<NOT_NULL>0</NOT_NULL>
<INTCOL_NUM>8</INTCOL_NUM>
<BASE_INTCOL_NUM>8</BASE_INTCOL_NUM>
<BASE_COL_TYPE>0</BASE_COL_TYPE>
<PROPERTY>0</PROPERTY>
<CHARSETID>0</CHARSETID>
<CHARSETFORM>0</CHARSETFORM>
<SPARE1>0</SPARE1>
<SPARE2>0</SPARE2>
<SPARE3>0</SPARE3>
</COL_LIST_ITEM>
</COL_LIST>
<CON0_LIST/>
<CON1_LIST>
<CON1_LIST_ITEM>
<OWNER_NUM>48</OWNER_NUM>
<NAME>SYS_C006994</NAME>
<CON_NUM>6994</CON_NUM>
<OBJ_NUM>20056</OBJ_NUM>
<PROPERTY>537919488</PROPERTY>
<NUMCOLS>1</NUMCOLS>
<CONTYPE>2</CONTYPE>
<ENABLED>0</ENABLED>
<INTCOLS>1</INTCOLS>
<MTIME>2016/12/06 16:11:45</MTIME>
<FLAGS>8</FLAGS>
<OID_OR_SETID>0</OID_OR_SETID>
<COL_LIST>
<COL_LIST_ITEM>
<CON_NUM>6994</CON_NUM>
<OBJ_NUM>20056</OBJ_NUM>
<INTCOL_NUM>1</INTCOL_NUM>
<POS_NUM>1</POS_NUM>
<SPARE1>0</SPARE1>
<OID_OR_SETID>0</OID_OR_SETID>
<COL>
<OBJ_NUM>20056</OBJ_NUM>
<COL_NUM>1</COL_NUM>
<INTCOL_NUM>1</INTCOL_NUM>
<SEGCOL_NUM>1</SEGCOL_NUM>
<PROPERTY>0</PROPERTY>

<NAME>EMPNO</NAME>
<TYPE_NUM>2</TYPE_NUM>
</COL>
</COL_LIST_ITEM>
</COL_LIST>
</CON1_LIST_ITEM>
</CON1_LIST>
<CON2_LIST>
<CON2_LIST_ITEM>
<OWNER_NUM>48</OWNER_NUM>
<NAME>CC01</NAME>
<CON_NUM>7022</CON_NUM>
<OBJ_NUM>20056</OBJ_NUM>
<NUMCOLS>1</NUMCOLS>
<CONTYPE>4</CONTYPE>
<ROBJ_NUM>20057</ROBJ_NUM>
<RCON_NUM>7005</RCON_NUM>
<ENABLED>1</ENABLED>
<INTCOLS>1</INTCOLS>
<MTIME>2016/12/06 16:14:12</MTIME>
<FLAGS>7</FLAGS>
<SCHEMA_OBJ>
<OBJ_NUM>20057</OBJ_NUM>
<DATAOBJ_NUM>20057</DATAOBJ_NUM>
<OWNER_NUM>48</OWNER_NUM>
<OWNER_NAME>SCOTT</OWNER_NAME>
<NAME>DEPT</NAME>
<NAMESPACE>1</NAMESPACE>
<TYPE_NUM>2</TYPE_NUM>
<TYPE_NAME>TABLE</TYPE_NAME>
<CTIME>2016-11-29 16:22:24</CTIME>
<MTIME>2016-12-07 14:20:37</MTIME>
<STIME>2016-11-29 16:22:24</STIME>
<STATUS>1</STATUS>
<FLAGS>0</FLAGS>
<SPARE1>6</SPARE1>
<SPARE2>1</SPARE2>
<SPARE3>48</SPARE3>
<OWNER_NAME2>SCOTT</OWNER_NAME2>
</SCHEMA_OBJ>
<SRC_COL_LIST>
<SRC_COL_LIST_ITEM>
<CON_NUM>7022</CON_NUM>
<OBJ_NUM>20056</OBJ_NUM>
<INTCOL_NUM>8</INTCOL_NUM>
<POS_NUM>1</POS_NUM>
<SPARE1>0</SPARE1>
<OID_OR_SETID>0</OID_OR_SETID>
<COL>
<OBJ_NUM>20056</OBJ_NUM>
<COL_NUM>8</COL_NUM>
<INTCOL_NUM>8</INTCOL_NUM>
<SEGCOL_NUM>8</SEGCOL_NUM>
<PROPERTY>0</PROPERTY>
<NAME>DEPTNO</NAME>
<TYPE_NUM>2</TYPE_NUM>
</COL>
</SRC_COL_LIST_ITEM>
</SRC_COL_LIST>
<TGT_COL_LIST>
<TGT_COL_LIST_ITEM>
<CON_NUM>7005</CON_NUM>
<OBJ_NUM>20057</OBJ_NUM>
<INTCOL_NUM>1</INTCOL_NUM>
<POS_NUM>1</POS_NUM>
<SPARE1>0</SPARE1>
<OID_OR_SETID>0</OID_OR_SETID>
<COL>
<OBJ_NUM>20057</OBJ_NUM>
<COL_NUM>1</COL_NUM>
<INTCOL_NUM>1</INTCOL_NUM>
<SEGCOL_NUM>1</SEGCOL_NUM>
<PROPERTY>0</PROPERTY>
<NAME>DEPTNO</NAME>
<TYPE_NUM>2</TYPE_NUM>
</COL>
</TGT_COL_LIST_ITEM>
</TGT_COL_LIST>
</CON2_LIST_ITEM>
</CON2_LIST>
<PKREF_LIST/>
<REFPAR_LEVEL>0</REFPAR_LEVEL>
</TABLE_T>
</ROW></ROWSET>

myscripts

Tuesday 11 April 2017

How to create an XML for creating a table in Oracle