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

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

<?xml version="1.0"?>
<!--

NAME
    kuobjtbl.xsl
DESCRIPTION
    XSLT stylesheet for XML => DDL conversion of object table ADTs
NOTES
    Do NOT modify this file under any circumstance. If you wish to use this
    stylesheet with an external XML/XSL parser, first make a copy then reverse
    the comments on any xsl:import statements appearing below.

MODIFIED	MM/DD/YY
    lbarton     06/17/09 - lrg 3543159: XMLType virtual columns
    shvenugo    03/23/09 - add store all varrays as lobs(tables) support
    rapayne     12/06/08 - merge BLOCKSIZE logic for CM
    htseng      03/20/06 - add xmltype binary support 
    lbarton     01/20/06 - code restructuring 
    lbarton     11/02/05 - Bug 4715313: reformat files for use with XMLSpy 
    lbarton     01/04/05 - bug 4017065: SUBSTITUTABLE on object table 
    rpfau       12/02/04 - Have callers of DoXMLTypeStorage emit XMLTYPE and
                           simplify call logic.
    lbarton     05/12/04 - Disentangle OID and EXPORT 
    rpfau       03/31/04 - Fix temporary table with name specified for 
                           oidindex - bug 3470762. Remove OidIndex template.
    bmccarth    10/30/03 - get REF correct for XMLSchemas 
    lbarton     09/02/03 - Bug 3103169: dataobjnum for oidindex storage 
    lbarton     03/20/03 - Bug 2859037: emit OID if EXPORT true
    bmccarth    03/31/03 - change call to lobmd
    lbarton     02/26/03 - emit owner with type synonym
    bmccarth    03/07/03 - add space after element num
    ataracha    02/19/03 - add space after out_of_line
    lbarton     01/30/03 - syntax for out-of-line tables
    bmccarth    10/08/02 - bug 2518404-xmlschema location
    bmccarth    08/15/02 - Move OID of table to after XMLTABLE
    bmccarth    08/08/02 - add space after oid value
    lbarton	04/03/02 - xdb bugfix
    lbarton     10/25/01 - xdb support
    dgagne      07/12/01 - fix OidIndex clause, missing index name
    gclaborn    11/03/00 - change name
    gclaborn    08/29/00 - use table, not type OID in OID clause
    lbarton	07/07/00 - bugfix: PkOid
    lbarton	05/17/00 - Params for new API
    lbarton	03/17/00 - Add module header
 -->
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
 <xsl:template name="ObjTable">
  
  <xsl:for-each select="COL_LIST/COL_LIST_ITEM[NAME='SYS_NC_ROWINFO$']/TYPEMD">
   <xsl:text>OF </xsl:text>
   <xsl:choose>
    <xsl:when test="SYN_NAME">
     <xsl:if test="SYN_OWNER!='PUBLIC'">
      <xsl:text>"</xsl:text>
      <xsl:value-of select="SYN_OWNER"/>
      <xsl:text>".</xsl:text>
     </xsl:if>
     <xsl:text>"</xsl:text>
     <xsl:value-of select="SYN_NAME"/>
     <xsl:text>"</xsl:text>
    </xsl:when>
    <xsl:otherwise>
     <xsl:apply-templates select="SCHEMA_OBJ"/>
    </xsl:otherwise>
   </xsl:choose>
   <xsl:if test="$OID=1">
    <xsl:if test="$PRETTY=1">
     <xsl:text>&#xa;</xsl:text>
    </xsl:if>
    <xsl:text> OID &apos;</xsl:text>
    <xsl:value-of select="../../../SCHEMA_OBJ/OID"/>
    
    <xsl:text>&apos; </xsl:text>
   </xsl:if>
   
   <xsl:choose>
    
    <xsl:when test="(FLAGS mod 4096)>= 2048">
     <xsl:if test="$PRETTY=1">
      <xsl:text>&#xa; </xsl:text>
     </xsl:if>
     <xsl:text> SUBSTITUTABLE AT ALL LEVELS </xsl:text>
    </xsl:when>
    
    <xsl:when test="(FLAGS mod 2048)>=1024">
     <xsl:if test="$PRETTY=1">
      <xsl:text>&#xa; </xsl:text>
     </xsl:if>
     <xsl:text> NOT SUBSTITUTABLE AT ALL LEVELS </xsl:text>
    </xsl:when>
   </xsl:choose>
   
   
   <xsl:if test="$PRETTY=1">
    <xsl:text>&#xa; </xsl:text>
   </xsl:if>
  </xsl:for-each>
 </xsl:template>
 <xsl:template name="DoOidindex">
  
   <xsl:choose>
    
    <xsl:when test="COL_LIST/COL_LIST_ITEM[NAME='SYS_NC_ROWINFO$']/OPQMD/SCHEMA_ELMT"/>
    <xsl:otherwise>
     <xsl:for-each select="COL_LIST/COL_LIST_ITEM/OIDINDEX">
      <xsl:choose>
       <xsl:when test="(../../../PROPERTY mod 8388608)>=4194304">
        
        
        <xsl:if test="(FLAGS mod 16) &lt; 8">
         
         <xsl:text>OIDINDEX </xsl:text>
         <xsl:value-of select="NAME"/>
         <xsl:if test="$PRETTY=1">
          <xsl:text>&#xa; </xsl:text>
         </xsl:if>
        </xsl:if>
       </xsl:when>
       <xsl:otherwise>
        
        <xsl:choose>
         <xsl:when test="$SEGMENT_ATTRIBUTES=0">
          
          
          <xsl:if test="(FLAGS mod 16) &lt; 8">
           <xsl:text>OIDINDEX </xsl:text>
           <xsl:value-of select="NAME"/>
           <xsl:if test="$PRETTY=1">
            <xsl:text>&#xa; </xsl:text>
           </xsl:if>
          </xsl:if>
         </xsl:when>
         <xsl:otherwise>
          
          <xsl:text>OIDINDEX </xsl:text>
          
          <xsl:if test="(FLAGS mod 16) &lt; 8">
           <xsl:value-of select="NAME"/>
          </xsl:if>
          <xsl:text> ( </xsl:text>
          <xsl:apply-templates select="PCT_FREE">
           <xsl:with-param name="ADT_type">INDEX</xsl:with-param>
          </xsl:apply-templates>
          
          
          
          <xsl:apply-templates select="STORAGE">
            <xsl:with-param name="BlkSize" select="../BLOCKSIZE | BLOCKSIZE"/>
           <xsl:with-param name="Dataobjnum" select="STORAGE/HWMINCR"/>
           <xsl:with-param name="Pctspace" select="$PCTSPACE"/>
          </xsl:apply-templates>
          <xsl:text>) </xsl:text>
          <xsl:if test="$PRETTY=1">
           <xsl:text>&#xa; </xsl:text>
          </xsl:if>
         </xsl:otherwise>
        </xsl:choose>
       </xsl:otherwise>
      </xsl:choose>
     </xsl:for-each>
    </xsl:otherwise>
   </xsl:choose>
 </xsl:template>
 <xsl:template name="PkOid">
  
  <xsl:text>(PRIMARY KEY (</xsl:text>
  <xsl:call-template name="DoConstraintColList">
   <xsl:with-param name="ColListNode" select="CON1_LIST/CON1_LIST_ITEM[CONTYPE='2']/COL_LIST"/>
  </xsl:call-template>
  <xsl:text>)) OBJECT ID PRIMARY KEY
 </xsl:text>
 </xsl:template>
 <xsl:template match="OPQMD/SCHEMA_ELMT">
  
  <xsl:apply-templates select="../../LOBMD"/>
  <xsl:call-template name="DoSchemaElmt">
   <xsl:with-param name="SchemaElmt" select="current()"/>
  </xsl:call-template>
  <xsl:call-template name="DoAllowDisallow">
   <xsl:with-param name="OpqmdElmt" select=".."/>
  </xsl:call-template>
  <xsl:if test="((../FLAGS) mod 64)>=32">
   <xsl:text>OUT_OF_LINE </xsl:text>
  </xsl:if>
 </xsl:template>
 <xsl:template match="LOBMD">
  
  <xsl:call-template name="DoXMLTypeStorage"/>
  <xsl:if test="$PRETTY=1">
   <xsl:text>&#xa;</xsl:text>
  </xsl:if>
 </xsl:template>
 <xsl:template name="DoSchemaElmt">
  <xsl:param name="SchemaElmt" select="''"/>
  
  <xsl:text> XMLSCHEMA "</xsl:text>
  <xsl:value-of select="$SchemaElmt/XMLSCHEMA"/>
  <xsl:text>" ELEMENT "</xsl:text>
  <xsl:value-of select="$SchemaElmt/ELEMENT_NAME"/>
  <xsl:text>" ID </xsl:text>
  <xsl:value-of select="$SchemaElmt/ELEMNUM"/>
  <xsl:text> </xsl:text>
 </xsl:template>
 <xsl:template name="DoAllowDisallow">
  <xsl:param name="OpqmdElmt" select="''"/>
  
  <xsl:if test="(($OpqmdElmt/FLAGS) mod 4096)>=2048 and $VERSION >= 1102000000">
   <xsl:text>STORE ALL VARRAYS AS LOBS </xsl:text>
   <xsl:if test="$PRETTY=1">
    <xsl:text>&#xa;  </xsl:text>
   </xsl:if>
  </xsl:if>
  <xsl:if test="(($OpqmdElmt/FLAGS) mod 128)>=64">
   <xsl:choose>
    <xsl:when test="(($OpqmdElmt/FLAGS) mod 512 )>=256">
     <xsl:text>DISALLOW NONSCHEMA </xsl:text>
    </xsl:when>
    <xsl:otherwise>
     <xsl:text>ALLOW NONSCHEMA </xsl:text>
    </xsl:otherwise>
   </xsl:choose>
   <xsl:choose>
    <xsl:when test="(($OpqmdElmt/FLAGS) mod 256 )>=128">
     <xsl:text>ALLOW ANYSCHEMA </xsl:text>
    </xsl:when>
    <xsl:when test="(($OpqmdElmt/FLAGS) mod 512 )&lt;256">
     <xsl:text>DISALLOW ANYSCHEMA </xsl:text>
    </xsl:when>
   </xsl:choose>
   <xsl:if test="$PRETTY=1">
    <xsl:text>&#xa;  </xsl:text>
   </xsl:if>
  </xsl:if>
 </xsl:template>
</xsl:stylesheet>

Ms-Dos/Windows Unix Write backup

jsp File Browser version 1.2 by www.vonloesch.de