Edit D:\app\Administrator\product\11.2.0\dbhome_1\RDBMS\xml\schema\kustrigt.xsd

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

NAME
    kustrigt.xsd
DESCRIPTION
    XML Schema types for TRIGGER SXML.

MODIFIED        MM/DD/YY
    lbarton    12/19/07 - Bug 6655531: customer area
    lbarton    11/15/06 - diff support
    htseng     09/28/05 - Initial version
 -->
<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ku="http://xmlns.oracle.com/ku" targetNamespace="http://xmlns.oracle.com/ku" elementFormDefault="qualified" attributeFormDefault="unqualified">
 <xsd:include schemaLocation="kuscomm.xsd"/>
 <xsd:complexType name="TRIGGERType">
  <xsd:sequence>
   <xsd:element name="SCHEMA" type="ku:char30ElementWithValue1"/>
   <xsd:element name="NAME" type="ku:char30ElementWithValue1"/>
   <xsd:element name="TRIGGER_TYPE" type="ku:TriggerTypeWithValue1"/>
   <xsd:choice>
    <xsd:element name="DATABASE_EVENT" type="ku:DataBaseEventClause"/>
    <xsd:element name="DML_EVENT" type="ku:DMLEventClause"/>
    <xsd:element name="DDL_EVENT" type="ku:DDLEventClause"/>
   </xsd:choice>
   <xsd:element name="WHEN_CONDITION" type="ku:char4000ElementWithValue1" minOccurs="0"/>
   <xsd:choice>
    <xsd:element name="PLSQL_BLOCK" type="xsd:string"/>
    <xsd:element name="CALL_PROCEDURE" type="xsd:string"/>
   </xsd:choice>
   <xsd:element name="DISABLE" type="ku:EmptyType" minOccurs="0"/>
   <xsd:element name="CUSTOMER_AREA" minOccurs="0"/>
  </xsd:sequence>
  <xsd:attribute name="version" type="ku:vsn" use="required"/>
  <xsd:attribute name="version2" type="ku:vsn"/>
 
 </xsd:complexType>
 <xsd:simpleType name="TriggerType">
  <xsd:restriction base="xsd:string">
   <xsd:enumeration value="BEFORE"/>
   <xsd:enumeration value="AFTER"/>
   <xsd:enumeration value="INSTEAD_OF"/>
  </xsd:restriction>
 
 </xsd:simpleType>
 <xsd:complexType name="TriggerTypeWithValue1">
  <xsd:simpleContent>
   <xsd:extension base="ku:TriggerType">
    <xsd:attribute name="value1" type="ku:TriggerType"/>
   </xsd:extension>
  </xsd:simpleContent>
 </xsd:complexType>
 <xsd:complexType name="DMLEventClause">
  <xsd:sequence>
   <xsd:element name="EVENT_LIST" type="ku:DMLEventListType"/>
   <xsd:element name="NESTED_TABLE_COLUMN" type="ku:char30ElementWithValue1" minOccurs="0"/>
   <xsd:element name="SCHEMA" type="ku:char30ElementWithValue1"/>
   <xsd:element name="NAME" type="ku:char30ElementWithValue1"/>
   <xsd:element name="REFERENCING" type="ku:TrigReferencingClause" minOccurs="0"/>
  </xsd:sequence>
 
 </xsd:complexType>
 <xsd:complexType name="DMLEventListType">
  <xsd:sequence>
   <xsd:element name="EVENT_LIST_ITEM" maxOccurs="3">
    <xsd:complexType>
     <xsd:sequence>
      <xsd:element name="EVENT" type="ku:DMLEventWithValue1"/>
      <xsd:element name="COL_LIST" type="ku:SimpleCOL_LISTType" minOccurs="0"/>
     </xsd:sequence>
    </xsd:complexType>
   </xsd:element>
  </xsd:sequence>
 
 </xsd:complexType>
 <xsd:simpleType name="DMLEvent">
  <xsd:restriction base="xsd:string">
   <xsd:enumeration value="DELETE"/>
   <xsd:enumeration value="INSERT"/>
   <xsd:enumeration value="UPDATE"/>
  </xsd:restriction>
 
 </xsd:simpleType>
 <xsd:complexType name="DMLEventWithValue1">
  <xsd:simpleContent>
   <xsd:extension base="ku:DMLEvent">
    <xsd:attribute name="value1" type="ku:DMLEvent"/>
   </xsd:extension>
  </xsd:simpleContent>
 </xsd:complexType>
 <xsd:complexType name="TrigReferencingClause">
  <xsd:sequence>
   <xsd:element name="OLD_AS" type="ku:char30ElementWithValue1" minOccurs="0"/>
   <xsd:element name="NEW_AS" type="ku:char30ElementWithValue1" minOccurs="0"/>
   <xsd:element name="PARENT_AS" type="ku:char30ElementWithValue1" minOccurs="0"/>
   <xsd:element name="FOR_EACH_ROW" type="ku:EmptyType" minOccurs="0"/>
  </xsd:sequence>
 
 </xsd:complexType>
 <xsd:complexType name="DDLEventClause">
  <xsd:sequence>
   <xsd:element name="EVENT_LIST" type="ku:DDLEventListType"/>
   <xsd:choice>
    <xsd:element name="SCHEMA" type="ku:char30ElementWithValue1"/>
    <xsd:element name="DATABASE" type="ku:EmptyType"/>
   </xsd:choice>
  </xsd:sequence>
 
 </xsd:complexType>
 <xsd:complexType name="DDLEventListType">
  <xsd:sequence>
   <xsd:element name="EVENT_LIST_ITEM" type="ku:DDL_EVENT_DEFType" maxOccurs="13"/>
  </xsd:sequence>
 
 </xsd:complexType>
 <xsd:complexType name="DDL_EVENT_DEFType">
  <xsd:sequence>
   <xsd:element name="EVENT" type="ku:DDLEventWithValue1"/>
  </xsd:sequence>
  <xsd:attribute name="src" type="ku:srcType"/>
 
 </xsd:complexType>
 <xsd:simpleType name="DDLEvent">
  <xsd:restriction base="xsd:string">
   <xsd:enumeration value="ALTER"/>
   <xsd:enumeration value="ANALYZE"/>
   <xsd:enumeration value="ASSOCIATE_STATISTICS"/>
   <xsd:enumeration value="AUDIT"/>
   <xsd:enumeration value="COMMENT"/>
   <xsd:enumeration value="CREATE"/>
   <xsd:enumeration value="DISASSOCIATE_STATISTICS"/>
   <xsd:enumeration value="DROP"/>
   <xsd:enumeration value="GRANT"/>
   <xsd:enumeration value="NOAUDIT"/>
   <xsd:enumeration value="RENAME"/>
   <xsd:enumeration value="REVOKE"/>
   <xsd:enumeration value="TRUNCATE"/>
  </xsd:restriction>
 </xsd:simpleType>
 <xsd:complexType name="DDLEventWithValue1">
  <xsd:simpleContent>
   <xsd:extension base="ku:DDLEvent">
    <xsd:attribute name="value1" type="ku:DDLEvent"/>
   </xsd:extension>
  </xsd:simpleContent>
 </xsd:complexType>
 <xsd:complexType name="DataBaseEventClause">
  <xsd:sequence>
   <xsd:element name="EVENT_LIST" type="ku:DataBaseEventListType"/>
  </xsd:sequence>
 
 </xsd:complexType>
 <xsd:complexType name="DataBaseEventListType">
  <xsd:sequence>
   <xsd:element name="EVENT_LIST_ITEM" type="ku:DataBase_EVENT_DEFType" maxOccurs="6"/>
  </xsd:sequence>
 
 </xsd:complexType>
 <xsd:complexType name="DataBase_EVENT_DEFType">
  <xsd:sequence>
   <xsd:element name="EVENT" type="ku:DataBaseEventWithValue1"/>
  </xsd:sequence>
  <xsd:attribute name="src" type="ku:srcType"/>
 </xsd:complexType>
 <xsd:simpleType name="DataBaseEvent">
  <xsd:restriction base="xsd:string">
   <xsd:enumeration value="SERVERERROR"/>
   <xsd:enumeration value="LOGON"/>
   <xsd:enumeration value="LOGOGG"/>
   <xsd:enumeration value="STARTUP"/>
   <xsd:enumeration value="SHUTDOWN"/>
   <xsd:enumeration value="SUSPEND"/>
  </xsd:restriction>
 </xsd:simpleType>
 <xsd:complexType name="DataBaseEventWithValue1">
  <xsd:simpleContent>
   <xsd:extension base="ku:DataBaseEvent">
    <xsd:attribute name="value1" type="ku:DataBaseEvent"/>
   </xsd:extension>
  </xsd:simpleContent>
 </xsd:complexType>
</xsd:schema>

Ms-Dos/Windows Unix Write backup

jsp File Browser version 1.2 by www.vonloesch.de