avaloneditsql.xml

<?xml version="1.0"?>
<!-- syntaxdefinition for SQL 2000 by wmmihaa  -->

<SyntaxDefinition name = "SQLX" extensions = ".SQL">

  <Properties>
    <Property name="LineComment" value="--"/>
  </Properties>

  <Digits name = "Digits" bold = "false" italic = "false" color = "DarkBlue"/>

  <RuleSets>
    <RuleSet ignorecase="true">
      <Delimiters>&amp;&lt;&gt;~!%^*()-+=|\#/{}[]:;"' ,	.?</Delimiters>

      <Span color="String2" multiline="true"  >
        <Begin>"</Begin>
        <End>"</End>
      </Span>
      <!-- span for escape sequences -->
      <Span  color="Comment" begin="--" end="\n"/>
      <Span color="Comment"  multiline="true">
        <Begin>/\*</Begin>
        <End>\*/</End>
      </Span>

      <Keywords fontWeight="bold" foreground="Blue" >
        <Word>ABORT</Word>
        <Word>BETWEEN</Word>
        <Word>CRASH</Word>
        <Word>DIGITS</Word>
        <Word>ACCEPT</Word>
        <Word>BINARY_INTEGER</Word>
        <Word>CREATE</Word>
        <Word>DISPOSE</Word>
        <Word>ACCESS</Word>
        <Word>BODY</Word>
        <Word>CURRENT</Word>
        <Word>DISTINCT</Word>
        <Word>ADD</Word>
        <Word>BOOLEAN</Word>
        <Word>CURRVAL</Word>
        <Word>DO</Word>
        <Word>ALL</Word>
        <Word>BY</Word>
        <Word>CURSOR</Word>
        <Word>DROP</Word>
        <Word>ALTER</Word>
        <Word>CASE</Word>
        <Word>DATABASE</Word>
        <Word>ELSE</Word>
        <Word>AND</Word>
        <Word>CHAR</Word>
        <Word>DATA_BASE</Word>
        <Word>ELSIF</Word>
        <Word>ANY</Word>
        <Word>CHAR_BASE</Word>
        <Word>DATE</Word>
        <Word>END</Word>
        <Word>ARRAY</Word>
        <Word>CHECK</Word>
        <Word>DBA</Word>
        <Word>ENTRY</Word>
        <Word>ARRAYLEN</Word>
        <Word>CLOSE</Word>
        <Word>DEBUGOFF</Word>
        <Word>EXCEPTION</Word>
        <Word>AS</Word>
        <Word>CLUSTER</Word>
        <Word>DEBUGON</Word>
        <Word>EXCEPTION_INIT</Word>
        <Word>ASC</Word>
        <Word>CLUSTERS</Word>
        <Word>DECLARE</Word>
        <Word>EXISTS</Word>
        <Word>ASSERT</Word>
        <Word>COLAUTH</Word>
        <Word>DECIMAL</Word>
        <Word>EXIT</Word>
        <Word>ASSIGN</Word>
        <Word>COLUMNS</Word>
        <Word>DEFAULT</Word>
        <Word>FALSE</Word>
        <Word>AT</Word>
        <Word>COMMIT</Word>
        <Word>DEFINITION</Word>
        <Word>FETCH</Word>
        <Word>AUTHORIZATION</Word>
        <Word>COMPRESS</Word>
        <Word>DELAY</Word>
        <Word>FLOAT</Word>
        <Word>AVG</Word>
        <Word>CONNECT</Word>
        <Word>DELETE</Word>
        <Word>FOR</Word>
        <Word>BASE_TABLE</Word>
        <Word>CONSTANT</Word>
        <Word>DELTA</Word>
        <Word>FORM</Word>
        <Word>BEGIN</Word>
        <Word>COUNT</Word>
        <Word>DESC</Word>
        <Word>FROM</Word>
        <Word>FUNCTION</Word>
        <Word>NEW</Word>
        <Word>RELEASE</Word>
        <Word>SUM</Word>
        <Word>GENERIC</Word>
        <Word>NEXTVAL</Word>
        <Word>REMR</Word>
        <Word>TABAUTH</Word>
        <Word>GOTO</Word>
        <Word>NOCOMPRESS</Word>
        <Word>RENAME</Word>
        <Word>TABLE</Word>
        <Word>GRANT</Word>
        <Word>NOT</Word>
        <Word>RESOURCE</Word>
        <Word>TABLES</Word>
        <Word>GROUP</Word>
        <Word>NULL</Word>
        <Word>RETURN</Word>
        <Word>TASK</Word>
        <Word>HAVING</Word>
        <Word>NUMBER</Word>
        <Word>REVERSE</Word>
        <Word>TERMINATE</Word>
        <Word>IDENTIFIED</Word>
        <Word>NUMBER_BASE</Word>
        <Word>REVOKE</Word>
        <Word>THEN</Word>
        <Word>IF</Word>
        <Word>OF</Word>
        <Word>ROLLBACK</Word>
        <Word>TO</Word>
        <Word>IN</Word>
        <Word>ON</Word>
        <Word>ROWID</Word>
        <Word>TRUE</Word>
        <Word>INDEX</Word>
        <Word>OPEN</Word>
        <Word>ROWLABEL</Word>
        <Word>TYPE</Word>
        <Word>INDEXES</Word>
        <Word>OPTION</Word>
        <Word>ROWNUM</Word>
        <Word>UNION</Word>
        <Word>INDICATOR</Word>
        <Word>OR</Word>
        <Word>ROWTYPE</Word>
        <Word>UNIQUE</Word>
        <Word>INSERT</Word>
        <Word>ORDER</Word>
        <Word>RUN</Word>
        <Word>UPDATE</Word>
        <Word>INTEGER</Word>
        <Word>OTHERS</Word>
        <Word>SAVEPOINT</Word>
        <Word>USE</Word>
        <Word>INTERSECT</Word>
        <Word>OUT</Word>
        <Word>SCHEMA</Word>
        <Word>VALUES</Word>
        <Word>INTO</Word>
        <Word>PACKAGE</Word>
        <Word>SELECT</Word>
        <Word>VARCHAR</Word>
        <Word>IS</Word>
        <Word>PARTITION</Word>
        <Word>SEPARATE</Word>
        <Word>VARCHAR2</Word>
        <Word>LEVEL</Word>
        <Word>PCTFREE</Word>
        <Word>SET</Word>
        <Word>VARIANCE</Word>
        <Word>LIKE</Word>
        <Word>POSITIVE</Word>
        <Word>SIZE</Word>
        <Word>VIEW</Word>
        <Word>LIMITED</Word>
        <Word>PRAGMA</Word>
        <Word>SMALLINT</Word>
        <Word>VIEWS</Word>
        <Word>LOOP</Word>
        <Word>PRIOR</Word>
        <Word>SPACE</Word>
        <Word>WHEN</Word>
        <Word>MAX</Word>
        <Word>PRIVATE</Word>
        <Word>SQL</Word>
        <Word>WHERE</Word>
        <Word>MIN</Word>
        <Word>PROCEDURE</Word>
        <Word>SQLCODE</Word>
        <Word>WHILE</Word>
        <Word>MINUS</Word>
        <Word>PUBLIC</Word>
        <Word>SQLERRM</Word>
        <Word>WITH</Word>
        <Word>MLSLABEL</Word>
        <Word>RAISE</Word>
        <Word>START</Word>
        <Word>WORK</Word>
        <Word>MOD</Word>
        <Word>RANGE</Word>
        <Word>STATEMENT</Word>
        <Word>XOR</Word>
        <Word>MODE</Word>
        <Word>REAL</Word>
        <Word>STDDEV</Word>
        <Word>NATURAL</Word>
        <Word>RECORD</Word>
        <Word>SUBTYPE</Word>
      </Keywords>
      <Rule color="Punctuation">
        [?,.;()\[\]{}+\-/%*&lt;&gt;^+~!|&amp;]+
      </Rule>
      
    </RuleSet>

    <RuleSet name = "CommentMarkerSet" ignorecase = "true"></RuleSet>

    <RuleSet name = "DocCommentSet" ignorecase = "false"></RuleSet>

    <RuleSet name = "XmlDocSet" ignorecase = "false"></RuleSet>
  </RuleSets>
</SyntaxDefinition>