//Language: PL SQL
//Copyright (c) 1992-2002 Altium Limited             
//All rights reserved.                               
//http://www.dream-com.com                           
//contact@dream-com.com                              

// states
State=snormal
State=sstring1
State=sstring2
State=scomment1
State=scomment2
// tokens
Token=tnone
Token=tstring
Token=tcomment
Token=tident
Token=tinteger
Token=tfloat
Token=tresword
Token=tassembler
Token=turl
Token=twhitespace
Token=tdirective
//delims
Delimiters=;.,:'"{}[]()?!@#$%^&*-+=|\/

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

// numbers
snormal [0-9][0-9]*                            snormal  tinteger
snormal [1-9][0-9]*\.[0-9]*                    snormal  tfloat
snormal [1-9][0-9]*{\.[0-9]+}|e{[\+\-]}|[0-9]+ snormal  tfloat

//idents

snormal   [a-z_A-Z][%a-z_A-Z0-9]*  snormal   tident

//white space
//snormal #32*                      snormal   twhitespace

//comments
snormal    --                     scomment1 tcomment
scomment1  [#1-#255]*             snormal   tcomment
scomment1 $                       snormal   tcomment
snormal   /\*                     scomment2 tcomment
scomment2 [^\*]*                  scomment2 tcomment
scomment2 \*[^/]                  scomment2 tcomment
scomment2 [\*]*/                  snormal   tcomment

//strings
snormal    \"                     sstring1   tstring
sstring1   [^\"]*                 sstring1   tstring
sstring1   \"                     snormal    tstring
sstring1   \"\"                   sstring1   tstring
sstring1   $                      snormal    tstring
//
snormal    \'                     sstring2   tstring
sstring2   [^\']*                 sstring2   tstring
sstring2   \'                     snormal    tstring
sstring2   \'\'                   sstring2   tstring
sstring2   $                      snormal    tstring