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

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

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

NAME
    kusviewd.xsl
DESCRIPTION
    Convert VIEW (SXML) document to creation DDL.

MODIFIED        MM/DD/YY
    rapayne    05/04/09 - Add READ ONLY for PARSED_SUBQUERY
    rapayne    12/09/08 - add COMMENTS support from CM code stream.
    lbarton    01/10/07 - PARSED_QUBQUERY
    akruglik   09/07/06 - Column Map Views got rechristened as Editioning Views
    rapayne    06/07/06 - add support for editioning views.
    lbarton    03/27/06 - bug 5118027: CONSTRAINTS and REF_CONSTRAINTS params 
                          for SXMLDDL 
    sdavidso   11/02/05 - fix inconsistent stylesheet format 
    htseng     09/08/05 - separate schemaname and name in under_clause 
    lbarton    08/10/05 - lbarton_mddiff
    htseng     05/16/05 - Initial version
 -->
<xsl:stylesheet version="1.0" xmlns:sxml="http://xmlns.oracle.com/ku" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
 
 <xsl:import href="kuscommd.xsl"/>
 <xsl:import href="kuscnstd.xsl"/>
 <xsl:import href="kusparsd.xsl"/>
 
 
 <xsl:param name="PRETTY">1</xsl:param>
 <xsl:param name="FORCE">1</xsl:param>
 <xsl:param name="REPLACE">1</xsl:param>
 <xsl:param name="SQLTERMINATOR">0</xsl:param>
 <xsl:param name="CONSTRAINTS">1</xsl:param>
 <xsl:param name="REF_CONSTRAINTS">1</xsl:param>
 
 <xsl:param name="COMMENTS">0</xsl:param>
 
 <xsl:template match="sxml:VIEW">
  <xsl:text>CREATE</xsl:text>
  <xsl:if test="$REPLACE=1">
   <xsl:text> OR REPLACE</xsl:text>
  </xsl:if>
  <xsl:if test="$FORCE=1"> FORCE</xsl:if>
  <xsl:if test="sxml:EDITIONING_VIEW">
    <xsl:text> EDITIONING </xsl:text>
  </xsl:if>
  <xsl:text> VIEW </xsl:text>
  <xsl:text>"</xsl:text>
  <xsl:value-of select="sxml:SCHEMA"/>
  <xsl:text>"."</xsl:text>
  <xsl:value-of select="sxml:NAME"/>
  <xsl:text>" </xsl:text>
  <xsl:if test="$PRETTY=1">
   <xsl:text>&#xa; </xsl:text>
  </xsl:if>
  <xsl:choose>
   <xsl:when test="sxml:COL_LIST">
    
    <xsl:text>( "</xsl:text>
    <xsl:for-each select="sxml:COL_LIST/sxml:COL_LIST_ITEM">
     <xsl:value-of select="sxml:NAME"/>
     <xsl:if test="position()!=last()">", "</xsl:if>
    </xsl:for-each>
    <xsl:text>"</xsl:text>
    <xsl:if test="sxml:CHECK_CONSTRAINT_LIST or
                  sxml:PRIMARY_KEY_CONSTRAINT_LIST or
                  sxml:UNIQUE_KEY_CONSTRAINT_LIST or
                  sxml:FOREIGN_KEY_CONSTRAINT_LIST or
                  sxml:SCOPE_CONSTRAINT_LIST or
                  sxml:ROWID_CONSTRAINT_LIST">
     <xsl:text>, </xsl:text>
    </xsl:if>
    <xsl:if test="$PRETTY=1">
     <xsl:text>&#xa; </xsl:text>
    </xsl:if>
    <xsl:call-template name="Constraints">
     <xsl:with-param name="ParentNode" select="."/>
    </xsl:call-template>
    <xsl:text> ) </xsl:text>
   </xsl:when>
   <xsl:when test="sxml:OF_TYPE">
    
    <xsl:apply-templates select="sxml:OF_TYPE"/>
    
    <xsl:call-template name="Constraints">
     <xsl:with-param name="ParentNode" select="."/>
    </xsl:call-template>
   </xsl:when>
   
   <xsl:when test="sxml:OF_XMLTYPE">
    <xsl:apply-templates select="sxml:OF_XMLTYPE"/>
   </xsl:when>
  </xsl:choose>
  
  <xsl:apply-templates select="sxml:SUBQUERY"/>
  <xsl:apply-templates select="sxml:PARSED_SUBQUERY"/>
  
  <xsl:if test="sxml:READ_ONLY and sxml:PARSED_SUBQUERY">
    <xsl:text> WITH READ ONLY </xsl:text>
  </xsl:if>
  
  <xsl:if test="$COMMENTS=1 and sxml:COMMENTS">
   <xsl:call-template name="CommentsOn">
    <xsl:with-param name="ObjectType">TABLE</xsl:with-param>
   </xsl:call-template>
  </xsl:if>
 </xsl:template>
 <xsl:template match="sxml:SUBQUERY">
 
   <xsl:text> AS </xsl:text>
   <xsl:if test="$PRETTY=1">
    <xsl:text>&#xa;  </xsl:text>
   </xsl:if>
   <xsl:value-of select="."/>
 </xsl:template>
 <xsl:template match="sxml:PARSED_SUBQUERY">
 
   <xsl:text> AS </xsl:text>
   <xsl:if test="$PRETTY=1">
    <xsl:text>&#xa;  </xsl:text>
   </xsl:if>
   <xsl:apply-templates select="*[1]">
    <xsl:with-param name="InnerQuery">0</xsl:with-param>
   </xsl:apply-templates>
 </xsl:template>
 
 <xsl:template match="sxml:OF_TYPE">
  <xsl:text> OF </xsl:text>
  <xsl:call-template name="SchemaName">
   <xsl:with-param name="ParentNode" select="."/>
  </xsl:call-template>
  <xsl:apply-templates select="sxml:WITH_OBJECT_IDENTIFIER"/>
  <xsl:apply-templates select="sxml:UNDER"/>
 </xsl:template>
 
 <xsl:template match="sxml:WITH_OBJECT_IDENTIFIER">
  <xsl:if test="$PRETTY=1">
   <xsl:text>&#xa; </xsl:text>
  </xsl:if>
  <xsl:text> WITH OBJECT IDENTIFIER (</xsl:text>
  <xsl:for-each select="sxml:ATTRIBUTE_LIST/sxml:ATTRIBUTE_LIST_ITEM">
   <xsl:value-of select="sxml:NAME"/>
   <xsl:if test="position()!=last()">,</xsl:if>
  </xsl:for-each>
  <xsl:text>) </xsl:text>
 </xsl:template>
 
 <xsl:template match="sxml:UNDER">
  <xsl:if test="$PRETTY=1">
   <xsl:text>&#xa; </xsl:text>
  </xsl:if>
  <xsl:text> UNDER </xsl:text>
  <xsl:if test="sxml:SCHEMA">
   <xsl:value-of select="sxml:SCHEMA"/>
   <xsl:text>.</xsl:text>
  </xsl:if>
  <xsl:value-of select="sxml:NAME"/>
  <xsl:text> </xsl:text>
 </xsl:template>
 
 <xsl:template match="sxml:OF_XMLTYPE">
  <xsl:text> OF XMLTYPE </xsl:text>
  <xsl:apply-templates select="sxml:XMLSCHEMA"/>
  <xsl:apply-templates select="sxml:ELEMENT"/>
  <xsl:apply-templates select="sxml:ID"/>
  <xsl:apply-templates select="sxml:WITH_OBJECT_IDENTIFIER"/>
 </xsl:template>
</xsl:stylesheet>

Ms-Dos/Windows Unix Write backup

jsp File Browser version 1.2 by www.vonloesch.de