Edit D:\app\Administrator\product\11.2.0\dbhome

Edit D:\app\Administrator\product\11.2.0\dbhome_1\RDBMS\xml\xsl\kustable.xsl

<?xml version="1.0"?>
<!--
 Copyright (c) 2004, 2009, Oracle and/or its affiliates.All rights reserved. 
NAME
    kustable.xsl
DESCRIPTION
    Convert mdapi TABLE_T document to TABLE document (SXML)

MODIFIED        MM/DD/YY
    ebatbout    12/16/08 - bug 6075698: add support for hidden_columns param
                           and recognize STRMTABLE_T keyword
    rapayne     12/24/08 - bug 759589: add $STATISTICS support from CM code stream.
    lbarton     08/28/08 - xmltype virtual columns
    lbarton     02/14/08 - flashback archive
    lbarton     03/19/08 - deferred segment creation
    abodge      01/22/07 - add COL_NUM attribute when MAKE_DIFF_READY is set.
    rapayne     11/27/06 - Integrate EM specific changes
    rapayne     07/14/06 - Sort by column name
    lbarton     06/23/06 - PARSE_EXPRESSIONS param 
    htseng      05/24/06 - virtual hidden support 
    lbarton     03/27/06 - bug 5118027: CONSTRAINTS and REF_CONSTRAINTS params 
                           for SXML 
    htseng      12/16/05 - add transform param 
    lbarton     11/08/05 - bug 4724986: fix handling of xmlns 
    sdavidso    11/02/05 - fix inconsistent stylesheet format 
    lbarton     09/14/05 - SXML syntax changes required by XML schema 
    lbarton     08/10/05 - lbarton_mddiff
    htseng      05/27/05 - pass PROPERTY to TablePhysicalProperties 
    lbarton     11/01/04 - Initial version
 -->
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns="http://xmlns.oracle.com/ku">
 
 <xsl:import href="kuscomm.xsl"/>
 <xsl:import href="kuscnstr.xsl"/>
 <xsl:import href="kustbphy.xsl"/>
 <xsl:import href="kuspar.xsl"/>
 
 <xsl:param name="PHYSICAL_PROPERTIES">1</xsl:param>
 <xsl:param name="SEGMENT_ATTRIBUTES">1</xsl:param>
 <xsl:param name="STORAGE">1</xsl:param>
 <xsl:param name="TABLESPACE">1</xsl:param>
 <xsl:param name="CONSTRAINTS">1</xsl:param>
 <xsl:param name="REF_CONSTRAINTS">1</xsl:param>
 <xsl:param name="PARTITIONING">1</xsl:param>
 <xsl:param name="OID">1</xsl:param>
 <xsl:param name="PARSE_EXPRESSIONS">0</xsl:param>
 <xsl:param name="STATISTICS">0</xsl:param>
 <xsl:param name="HIDDEN_COLUMNS">0</xsl:param>
 
 <xsl:template match="TABLE_T | STRMTABLE_T">
  
  <xsl:element name="TABLE">
   
   <xsl:attribute name="xmlns">http://xmlns.oracle.com/ku</xsl:attribute>
   <xsl:attribute name="version">1.0</xsl:attribute>
   <xsl:if test="(PROPERTY mod 8388608)>=4194304">
    <xsl:element name="GLOBAL_TEMPORARY"/>
   </xsl:if>
   <xsl:apply-templates select="SCHEMA_OBJ"/>
   <xsl:choose>
    <xsl:when test="(PROPERTY mod 2)=1">
     
     <xsl:choose>
      <xsl:when test="COL_LIST/COL_LIST_ITEM[NAME='SYS_NC_ROWINFO$']/TYPEMD/SCHEMA_OBJ/NAME='XMLTYPE'
              or 
         COL_LIST/COL_LIST_ITEM[NAME='SYS_NC_ROWINFO$']/TYPEMD/NAME='XMLTYPE'">
       <xsl:element name="XMLTYPE_TABLE">
        <xsl:call-template name="CreObjTable"/>
       </xsl:element>
      </xsl:when>
      <xsl:otherwise>
       <xsl:element name="OBJECT_TABLE">
        <xsl:call-template name="CreObjTable"/>
       </xsl:element>
      </xsl:otherwise>
     </xsl:choose>
    </xsl:when>
    <xsl:otherwise>
     <xsl:element name="RELATIONAL_TABLE">
      <xsl:call-template name="CreRelTable"/>
     </xsl:element>
    </xsl:otherwise>
   </xsl:choose>
   <xsl:if test="(string(ROWCNT) and not ($STATISTICS=0))">
    <xsl:element name="STATISTICS">
     <xsl:call-template name="CreTblStats"/>
    </xsl:element>
   </xsl:if>
  </xsl:element>
 </xsl:template>
 <xsl:template name="CreTblStats">
  
  <xsl:element name="ROWCNT">
   <xsl:value-of select="ROWCNT"/>
  </xsl:element>
  <xsl:element name="BLKCNT">
   <xsl:value-of select="BLKCNT"/>
  </xsl:element>
  <xsl:element name="EMPCNT">
   <xsl:value-of select="EMPCNT"/>
  </xsl:element>
  <xsl:element name="AVGSPC">
   <xsl:value-of select="AVGSPC"/>
  </xsl:element>
  <xsl:element name="CHNCNT">
   <xsl:value-of select="CHNCNT"/>
  </xsl:element>
  <xsl:element name="AVGRLN">
   <xsl:value-of select="AVGRLN"/>
  </xsl:element>
  <xsl:element name="AVGSPC_FLB">
   <xsl:value-of select="AVGSPC_FLB"/>
  </xsl:element>
  <xsl:element name="FLBCNT">
   <xsl:value-of select="FLBCNT"/>
  </xsl:element>
  <xsl:element name="ANALYZETIME">
   <xsl:value-of select="ANALYZETIME"/>
  </xsl:element>
  <xsl:element name="SAMPLESIZE">
   <xsl:value-of select="SAMPLESIZE"/>
  </xsl:element>
 </xsl:template>
 <xsl:template name="CreRelTable">
  
  
  <xsl:element name="COL_LIST">
   
   <xsl:choose>
    <xsl:when test="$MAKE_DIFF_READY=1">
     <xsl:for-each select="COL_LIST/COL_LIST_ITEM[(PROPERTY mod 64)&lt;32
	     or ((PROPERTY mod 512)&lt;256 and (PROPERTY mod 131072)>= 65536)  
             or (PROPERTY mod 2097152)>=1048576
             or (PROPERTY mod 8388608)>=4194304]">
      <xsl:sort select="NAME" data-type="text" lang="en"/>
      <xsl:element name="COL_LIST_ITEM">
       
       <xsl:attribute name="NAME"><xsl:value-of select="NAME"/></xsl:attribute>
       
       <xsl:attribute name="col-num"><xsl:value-of select="COL_NUM"/></xsl:attribute>
       <xsl:call-template name="ColumnDefinition"/>
      </xsl:element>
     </xsl:for-each>
    </xsl:when>
    <xsl:otherwise>
     
     <xsl:for-each select="COL_LIST/COL_LIST_ITEM[(PROPERTY mod 64)&lt;32
             or (not($HIDDEN_COLUMNS=0) and ((PROPERTY mod 64)>=32))
	     or ((PROPERTY mod 512)&lt;256 and (PROPERTY mod 131072)>= 65536)  
                      or (PROPERTY mod 2097152)>=1048576
                      or (PROPERTY mod 8388608)>=4194304]">
      <xsl:element name="COL_LIST_ITEM">
       <xsl:call-template name="ColumnDefinition">
        <xsl:with-param name="ExternalTable" select="$HIDDEN_COLUMNS"/>
       </xsl:call-template>
      </xsl:element>
     </xsl:for-each>
    </xsl:otherwise>
   </xsl:choose>
  </xsl:element>
  
  <xsl:call-template name="TableConstraints"/>
  
  <xsl:call-template name="SupplementalLogging"/>
  <xsl:choose>
   <xsl:when test="(PROPERTY mod 8388608)>=4194304">
    
    
    <xsl:call-template name="OnCommit">
     <xsl:with-param name="Property" select="PROPERTY"/>
    </xsl:call-template>
   </xsl:when>
   <xsl:otherwise>
    
    <xsl:if test="(PROPERTY mod 64)&lt;32">
     <xsl:call-template name="TablePhysicalProperties">
      <xsl:with-param name="PROPERTY" select="PROPERTY"/>
      <xsl:with-param name="PROPERTY2" select="PROPERTY2"/>
     </xsl:call-template>
    </xsl:if>
    
    <xsl:call-template name="TableProperties"/>
   </xsl:otherwise>
  </xsl:choose>
 </xsl:template>
 <xsl:template name="OnCommit">
  <xsl:param name="Property">0</xsl:param>
  
  <xsl:if test="($Property mod 8388608)>=4194304">
   
   <xsl:element name="ON_COMMIT">
    <xsl:choose>
     <xsl:when test="($Property mod 16777216)>=8388608">
      <xsl:text>PRESERVE</xsl:text>
     </xsl:when>
     <xsl:otherwise>
      <xsl:text>DELETE</xsl:text>
     </xsl:otherwise>
    </xsl:choose>
   </xsl:element>
  </xsl:if>
 </xsl:template>
 <xsl:template name="TableProperties">
  
  
  <xsl:if test="(COL_LIST/COL_LIST_ITEM[(TYPE_NUM=121)
          and not (NAME='SYS_NC_ROWINFO$')
          and (32768>(PROPERTY mod 65536))
          and ((TYPEMD/FLAGS mod 4096)>= 2048 or
               (TYPEMD/FLAGS mod 2048)>= 1024 or
               (TYPEMD/SUBTYPE_LIST/SUBTYPE_LIST_ITEM/FLAGS mod 4)=3)])
        or
        (COL_LIST/COL_LIST_ITEM[(TYPE_NUM=122)
                              and (32768>(PROPERTY mod 65536))])
        or
        (COL_LIST/COL_LIST_ITEM[(TYPE_NUM=123)
                              and (256>(PROPERTY mod 512))
                              and (32768>(PROPERTY mod 65536))
                              and (((TYPEMD/FLAGS mod 128)>=64)
                              or   ((TYPEMD/FLAGS mod 8)>=4))])
        or
        (COL_LIST/COL_LIST_ITEM[(TYPE_NUM=112 or TYPE_NUM=113)
                              and (32768>(PROPERTY mod 65536))
                              and (256>(PROPERTY mod 512))]
                              and not ($SEGMENT_ATTRIBUTES=0)
                              and not ($PHYSICAL_PROPERTIES=0)
                              and not ($TABLESPACE=0))
        or
        (COL_LIST/COL_LIST_ITEM[(TYPE_NUM=58) 
                              and (32768>(PROPERTY mod 65536))
                              and (256>(PROPERTY mod 512))
                              and not ((OPQMD/FLAGS mod 4)>=2)]/LOBMD)
        or
        (COL_LIST/COL_LIST_ITEM[(TYPE_NUM=58)
                              and not (NAME='SYS_NC_ROWINFO$')
                              and (32768>(PROPERTY mod 65536))
                              and (TYPEMD/SCHEMA_OBJ/OWNER_NAME='SYS')
                              and (TYPEMD/SCHEMA_OBJ/NAME='XMLTYPE')
                              and (OPQMD/SCHEMA_ELMT)])
        or
        (COL_LIST/COL_LIST_ITEM[(PROPERTY mod 16 >= 8) and
           (PROPERTY mod 64 >= 32) and
           (PROPERTY mod 131052 >= 65536) and
           (256 > (PROPERTY mod 512)) and
           (512 > (PROPERTY mod 1024)) and
           (16384 > (PROPERTY mod 32768))])
        or
        (PART_OBJ)
        or
        (FLAGS mod 16)>=8
        or
        DEGREE
        or
        (FLAGS mod 16777216)>=8388608
        or
        (FLAGS mod 262144)>=131072
        or
        FBA">
   
   <xsl:element name="TABLE_PROPERTIES">
    
    <xsl:call-template name="TableColumnProperties">
     <xsl:with-param name="ColListParent" select="."/>
     <xsl:with-param name="NTNode" select="NT"/>
     <xsl:with-param name="TabBlocksize" select="BLOCKSIZE"/>
    </xsl:call-template>
    
    <xsl:call-template name="XMLTypeVirtualColumns">
     <xsl:with-param name="VirtualCols" select="COL_LIST/COL_LIST_ITEM[(PROPERTY mod 16 >= 8) and
           (PROPERTY mod 64 >= 32) and
           (PROPERTY mod 131052 >= 65536) and
           (256 > (PROPERTY mod 512)) and
           (512 > (PROPERTY mod 1024)) and
           (16384 > (PROPERTY mod 32768))]"/>
    </xsl:call-template>
    
    <xsl:if test="PART_OBJ">
     <xsl:call-template name="TablePartitioning">
      <xsl:with-param name="PartobjNode" select="PART_OBJ"/>
      <xsl:with-param name="PropertyNode" select="PROPERTY"/>
      <xsl:with-param name="ColListNode" select="COL_LIST"/>
      <xsl:with-param name="TabBlocksize" select="BLOCKSIZE"/>
     </xsl:call-template>
    </xsl:if>
    
    <xsl:if test="(FLAGS mod 16)>=8">
     <xsl:element name="CACHE"/>
    </xsl:if>
    
    <xsl:call-template name="ParallelClause">
     <xsl:with-param name="ParentNode" select="."/>
    </xsl:call-template>
    
    <xsl:if test="(FLAGS mod 16777216)>=8388608">
     <xsl:element name="ROW_DEPENDENCIES"/>
    </xsl:if>
    
    <xsl:if test="(FLAGS mod 262144)>=131072">
     <xsl:element name="ROW_MOVEMENT"/>
    </xsl:if>
    
    <xsl:apply-templates select="FBA"/>
   </xsl:element>
  </xsl:if>
 </xsl:template>
 <xsl:template match="FBA">
  
  <xsl:element name="FLASHBACK_ARCHIVE">
   <xsl:value-of select="FA_NAME"/>
  </xsl:element>
 </xsl:template>
 <xsl:template name="CreObjTable">
  
  
  <xsl:for-each select="COL_LIST/COL_LIST_ITEM[NAME='SYS_NC_ROWINFO$']/TYPEMD">
   
   <xsl:element name="OF_TYPE">
    <xsl:choose>
     <xsl:when test="SYN_NAME">
      <xsl:if test="SYN_OWNER">
       <xsl:element name="SCHEMA">
        <xsl:value-of select="SYN_OWNER"/>
       </xsl:element>
      </xsl:if>
      <xsl:element name="NAME">
       <xsl:value-of select="SYN_NAME"/>
      </xsl:element>
     </xsl:when>
     <xsl:otherwise>
      <xsl:apply-templates select="SCHEMA_OBJ"/>
     </xsl:otherwise>
    </xsl:choose>
   </xsl:element>
   
   <xsl:choose>
    
    <xsl:when test="(FLAGS mod 4096)>= 2048">
     <xsl:element name="SUBSTITUTABLE">Y</xsl:element>
    </xsl:when>
    
    <xsl:when test="(FLAGS mod 2048)>=1024">
     <xsl:element name="SUBSTITUTABLE">N</xsl:element>
    </xsl:when>
   </xsl:choose>
  </xsl:for-each>
  
  <xsl:if test="(COL_LIST/COL_LIST_ITEM[(DEFLENGTH!=0 or ($HIDDEN_COLUMNS=1))
                and (($HIDDEN_COLUMNS=1) or (32 > (PROPERTY mod 64)))   
		and (1024 > (PROPERTY mod 1024))]) or
              (COL_LIST/COL_LIST_ITEM[CON/CONTYPE='7' or CON/CONTYPE='11'])">
   <xsl:element name="OBJECT_COLUMN_PROPERTIES">
    <xsl:element name="COL_LIST">
     <xsl:for-each select="(COL_LIST/COL_LIST_ITEM[(
                       (DEFLENGTH != 0 or ($HIDDEN_COLUMNS=1)) and
                      (($HIDDEN_COLUMNS=1) or (32 > (PROPERTY mod 64)))   
		      and (1024 > (PROPERTY mod 1024))) or
                      (CON/CONTYPE='7' or CON/CONTYPE='11')])">
      <xsl:element name="COL_LIST_ITEM">
       <xsl:element name="NAME">
        <xsl:value-of select="NAME"/>
       </xsl:element>
       <xsl:if test="DEFAULT_VAL">
        <xsl:element name="DEFAULT">
         <xsl:apply-templates select="DEFAULT_VAL"/>
        </xsl:element>
       </xsl:if>
       <xsl:if test="TYPE_NUM and (not($HIDDEN_COLUMNS=0))">
        <xsl:apply-templates select="TYPE_NUM">
         <xsl:with-param name="ParentNode" select="."/>
        </xsl:apply-templates>
       </xsl:if>
       <xsl:if test="CON/CONTYPE='7' or CON/CONTYPE='11'">
        <xsl:element name="NOT_NULL">
         <xsl:if test="(CON/FLAGS mod 16)&lt;8">
          <NAME>
           <xsl:value-of select="CON/NAME"/>
          </NAME>
         </xsl:if>
         <xsl:call-template name="EnableDisable">
          <xsl:with-param name="ConNode" select="CON"/>
         </xsl:call-template>
        </xsl:element>
       </xsl:if>
       <xsl:if test="SEGCOL_NUM and (not($HIDDEN_COLUMNS=0))">
        <xsl:element name="SEGCOL_NUM">
         <xsl:value-of select="SEGCOL_NUM"/>
        </xsl:element>
       </xsl:if>
       <xsl:if test="INTCOL_NUM and (not($HIDDEN_COLUMNS=0))">
        <xsl:element name="INTCOL_NUM">
         <xsl:value-of select="INTCOL_NUM"/>
        </xsl:element>
        <xsl:if test="(PROPERTY mod 131072)>=65536">
         <xsl:element name="VIRTUAL"/>
        </xsl:if>
       </xsl:if>
      </xsl:element>
     </xsl:for-each>
    </xsl:element>
   </xsl:element>
  </xsl:if>
  
  <xsl:call-template name="TableConstraints"/>
  <xsl:if test="COL_LIST/COL_LIST_ITEM[NAME='SYS_NC_ROWINFO$']/OPQMD/SCHEMA_ELMT">
   
   
   <xsl:call-template name="XMLTypeStorage">
    <xsl:with-param name="ColNode" select="COL_LIST/COL_LIST_ITEM[NAME='SYS_NC_ROWINFO$']"/>
    <xsl:with-param name="TabBlocksize" select="BLOCKSIZE"/>
   </xsl:call-template>
   
   <xsl:call-template name="XMLSchemaSpec">
    <xsl:with-param name="ColNode" select="COL_LIST/COL_LIST_ITEM[NAME='SYS_NC_ROWINFO$']"/>
   </xsl:call-template>
  </xsl:if>
  
  <xsl:if test="(PROPERTY mod 8388608)>=4194304">
   
   <xsl:call-template name="OnCommit">
    <xsl:with-param name="Property" select="PROPERTY"/>
   </xsl:call-template>
  </xsl:if>
  
  <xsl:choose>
   
   <xsl:when test="$OID!=1">
    <xsl:element name="OID">
     <xsl:value-of select="SCHEMA_OBJ/OID"/>
    </xsl:element>
   </xsl:when>
   <xsl:when test="CON1_LIST/CON1_LIST_ITEM[CONTYPE='2']">
    <xsl:element name="OID">
     <xsl:choose>
      
      <xsl:when test="(PROPERTY mod 8192)>=4096">PRIMARY_KEY</xsl:when>
      
      <xsl:otherwise>SYSTEM_GENERATED</xsl:otherwise>
     </xsl:choose>
    </xsl:element>
   </xsl:when>
  </xsl:choose>
  
  <xsl:if test="COL_LIST/COL_LIST_ITEM/OIDINDEX
                 and not
       (COL_LIST/COL_LIST_ITEM[NAME='SYS_NC_ROWINFO$']/OPQMD and
       COL_LIST/COL_LIST_ITEM[NAME='SYS_NC_ROWINFO$']/OPQMD/SCHEMA_ELMT)">
   <xsl:call-template name="OidIndex">
    <xsl:with-param name="ColNode" select="COL_LIST/COL_LIST_ITEM[OIDINDEX]"/>
    <xsl:with-param name="TabProperty" select="PROPERTY"/>
   </xsl:call-template>
  </xsl:if>
  <xsl:if test="4194304>(PROPERTY mod 8388608)">
   
   
   <xsl:if test="(PROPERTY mod 64)&lt;32">
    <xsl:call-template name="TablePhysicalProperties">
     <xsl:with-param name="PROPERTY" select="PROPERTY"/>
    </xsl:call-template>
   </xsl:if>
   
   <xsl:call-template name="TableProperties"/>
  </xsl:if>
 </xsl:template>
 <xsl:template name="OidIndex">
  <xsl:param name="ColNode" select="''"/>
  <xsl:param name="TabProperty">0</xsl:param>
  
  <xsl:if test="not ($SEGMENT_ATTRIBUTES=0) and not ($PHYSICAL_PROPERTIES=0)">
   
   <xsl:if test="4194304>(PROPERTY mod 8388608) or
               (($ColNode/OIDINDEX/FLAGS mod 16) &lt; 8)">
    <xsl:element name="OIDINDEX">
     
     <xsl:if test="($ColNode/OIDINDEX/FLAGS mod 16) &lt; 8">
      <xsl:call-template name="ColName">
       <xsl:with-param name="ColNode" select="$ColNode/OIDINDEX"/>
      </xsl:call-template>
     </xsl:if>
     
     <xsl:if test="($TabProperty mod 8388608) &lt; 4194304">
      <xsl:call-template name="PhysicalAttributes">
       <xsl:with-param name="ParentNode" select="$ColNode/OIDINDEX"/>
       <xsl:with-param name="Partitioned" select="0"/>
       <xsl:with-param name="ObjType" select="TABLE"/>
      </xsl:call-template>
      <xsl:call-template name="Tablespace">
       <xsl:with-param name="ParentNode" select="$ColNode/OIDINDEX"/>
      </xsl:call-template>
     </xsl:if>
    </xsl:element>
   </xsl:if>
  </xsl:if>
 </xsl:template>
</xsl:stylesheet>

Ms-Dos/Windows Unix Write backup

jsp File Browser version 1.2 by www.vonloesch.de