#define st_DEFAULT                     0
#define st_COMMENT                     1
#define st_IDENTIFIER                  2
#define st_STRING                      3
#define st_NUMBER                      4
#define st_SYMBOL                      5
#define st_SQLRESERVED                 6
#define st_PLSQLRESERVED               7
#define st_SQLFUNCTION                 8
#define st_DEFAULTPACKAGE              9
#define st_DEFAULTEXCEPTION           10
#define st_DEFAULTPACKAGEEXCEPTION    11
#define st_COMMENT_LINE               12
#define st_COMMENT_STAR               13
#define st_RESERVED                   14
#define st_EXCEPTION                  15
#define st_CONSTANT                   16
#define st_DEFAULTPACKAGECONSTANT     17
#define st_DATATYPE                   18
#define st_SQLDATATYPE                19
#define st_PLSQLDATATYPE              20
#define st_DEFAULTPACKAGEDATATYPE     21
#define st_TABLENAMES                 22
#define st_USERPROCEDURES             23

#define _non_alpha_                 '[^_A-Za-z0-9]'
#define _all_chars_                 '[\x00-\xFF]'
#define _no_chars_                  '[]'
#define _dont_care_                 _all_chars_
#define _DEFAULT_BACKGROUND         clWhite
#define _DEFAULT_FOREGROUND         clBlack
#define ss_D1  200
#define ss_D2  201
#define ss_D3  202
#define ss_D4  203

%%language
StartState                = [0, ss_D1, ss_D2, ss_D3, ss_D4]
Name                      = 'PL/SQL'
Case                      = __INSENSITIVE
Options                   = __DEFAULT_OPTIONS
WordWrapColumn            = _EDGE
Gutter                    = _DEFAULT_GUTTER
Anchor                    = _DEFAULT_START_ANCHOR
IndentStep                = 1
FontName                  = 'Courier New'
FontSize                  = 10
ExampleText               = '\DECLARE\n\
                            \  c_ausw_nr  CONSTANT VARCHAR2(4) := \'14\';\n\
                            \  v_book     book%ROWTYPE;\n\
                            \ \n\
                            \BEGIN\n\
                            \  DELETE FROM commercial\n\
                            \END;\n'

EditableStyles              ('Reserved word', st_RESERVED),
                            ('SQL Functions', st_SQLFUNCTION),
                            ('Default Packages', st_DEFAULTPACKAGE),
                            ('Exceptions',    st_EXCEPTION),
                            ('Comment',       st_COMMENT),
                            ('Identifier',    st_IDENTIFIER),
                            ('String',        st_STRING),
                            ('Number',        st_NUMBER),
                            ('Symbols',       st_SYMBOL),
                            ('Datatypes',     st_DATATYPE),
                            ('Table Names',   st_TABLENAMES),
                            ('Sql Reserved',   st_SQLRESERVED),
                            ('PLSql Reserved',   st_PLSQLRESERVED),
                            ('Default Exceptions',   st_DEFAULTEXCEPTION),
                            ('User Procedures',   st_USERPROCEDURES),
                            ('Default',       st_DEFAULT)


%%handler
st_COMMENT_LINE         '[^\n]'?                    '\n'           _discard_
st_COMMENT_STAR         _all_chars_?                '*/'           _use_

%%tokens
st_STRING               __STD_PASCALSTRING
st_STRING               __STD_C_STRING
st_NUMBER               __STD_NUMBER_OR_FP
st_IDENTIFIER           __STD_IDENTIFIER

%%map
st_DEFAULT                              st_DEFAULT
st_IDENTIFIER                           st_IDENTIFIER
st_STRING                               st_STRING
st_COMMENT                              st_COMMENT
st_COMMENT_LINE                         st_COMMENT
st_COMMENT_STAR                         st_COMMENT
st_SQLRESERVED                          st_RESERVED
st_PLSQLRESERVED                        st_RESERVED
st_SQLFUNCTION                          st_SQLFUNCTION
st_DEFAULTPACKAGE                       st_DEFAULTPACKAGE
st_DEFAULTPACKAGEEXCEPTION              st_EXCEPTION
st_DEFAULTEXCEPTION                     st_EXCEPTION
st_SYMBOL                               st_SYMBOL
st_NUMBER                               st_NUMBER
st_CONSTANT                             st_CONSTANT
st_DEFAULTPACKAGECONSTANT               st_CONSTANT
st_DEFAULTPACKAGEDATATYPE               st_DATATYPE
st_SQLDATATYPE                          st_DATATYPE
st_PLSQLDATATYPE                        st_DATATYPE
st_DATATYPE                             st_DATATYPE
st_TABLENAMES                           st_TABLENAMES
st_USERPROCEDURES                       st_USERPROCEDURES

%%effects
st_DEFAULT          []          _DEFAULT_FOREGROUND   _DEFAULT_BACKGROUND
st_IDENTIFIER       []          clBlack               _DEFAULT_BACKGROUND
st_STRING           []          clRed                 _DEFAULT_BACKGROUND
st_COMMENT          [fsItalic]  clGreen               _DEFAULT_BACKGROUND
st_RESERVED         []          clBlue                _DEFAULT_BACKGROUND
st_SQLFUNCTION      []          _DEFAULT_FOREGROUND   _DEFAULT_BACKGROUND
st_DEFAULTPACKAGE   []          clblue                _DEFAULT_BACKGROUND
st_EXCEPTION        []          clred                 _DEFAULT_BACKGROUND
st_NUMBER           []          clMaroon              _DEFAULT_BACKGROUND
st_SYMBOL           []          clBlue                _DEFAULT_BACKGROUND
st_DATATYPE         []          clRed                 _DEFAULT_BACKGROUND
st_CONSTANT         []          _DEFAULT_FOREGROUND   _DEFAULT_BACKGROUND
st_TABLENAMES       []          clOlive              _DEFAULT_BACKGROUND
st_USERPROCEDURES   []          clOlive              _DEFAULT_BACKGROUND


%%autoreplace    ActionKeys    = ';,:=[]\n\t\s'
        'NDF'         = 'NO_DATA_FOUND'
        'teh'         = 'the'
        '(c)'         = '