1 # Define SciTE settings for SQL and PL/SQL files.
3 filter.sql=SQL (sql)|*.sql|
5 file.patterns.sql=*.sql
6 file.patterns.plsql=*.spec;*.body;*.sps;*.spb;*.sf;*.sp
8 lexer.$(file.patterns.sql)=sql
9 lexer.$(file.patterns.plsql)=sql
13 style.sql.0=fore:#808080
15 style.sql.1=fore:#007F00,$(font.comment)
17 style.sql.2=fore:#007F00,$(font.comment)
19 style.sql.3=fore:#7F7F7F
21 style.sql.4=fore:#007F7F
23 style.sql.5=fore:#00007F,bold
24 # Double quoted string
25 style.sql.6=fore:#7F007F,$(font.monospace)
26 # Single quoted string
27 style.sql.7=fore:#7F007F,$(font.monospace)
29 style.sql.8=fore:#007F7F
31 style.sql.9=fore:#7F7F00
36 # End of line where string is not closed
37 style.sql.12=fore:#000000,$(font.monospace),back:#E0C0E0,eolfilled
39 style.sql.15=fore:#007F00,$(font.comment)
40 # Braces are only matched in operator style
42 # Enables backslash as an escape character
43 #sql.backslash.escapes=1
45 keywords.$(file.patterns.sql)=\
46 absolute action add admin after aggregate \
47 alias all allocate alter and any are array as asc \
48 assertion at authorization \
49 before begin binary bit blob boolean both breadth by \
50 call cascade cascaded case cast catalog char character \
51 check class clob close collate collation column commit \
52 completion connect connection constraint constraints \
53 constructor continue corresponding create cross cube current \
54 current_date current_path current_role current_time current_timestamp \
55 current_user cursor cycle \
56 data date day deallocate dec decimal declare default \
57 deferrable deferred delete depth deref desc describe descriptor \
58 destroy destructor deterministic dictionary diagnostics disconnect \
59 distinct domain double drop dynamic \
60 each else end end-exec equals escape every except \
61 exception exec execute external \
62 false fetch first float for foreign found from free full \
64 general get global go goto grant group grouping \
66 identity if ignore immediate in indicator initialize initially \
67 inner inout input insert int integer intersect interval \
68 into is isolation iterate \
71 language large last lateral leading left less level like \
72 limit local localtime localtimestamp locator \
73 map match minute modifies modify module month \
74 names national natural nchar nclob new next no none \
76 object of off old on only open operation option \
77 or order ordinality out outer output \
78 pad parameter parameters partial path postfix precision prefix \
79 preorder prepare preserve primary \
80 prior privileges procedure public \
81 read reads real recursive ref references referencing relative \
82 restrict result return returns revoke right \
83 role rollback rollup routine row rows \
84 savepoint schema scroll scope search second section select \
85 sequence session session_user set sets size smallint some| space \
86 specific specifictype sql sqlexception sqlstate sqlwarning start \
87 state statement static structure system_user \
88 table temporary terminate than then time timestamp \
89 timezone_hour timezone_minute to trailing transaction translation \
91 under union unique unknown \
92 unnest update usage user using \
93 value values varchar variable varying view \
94 when whenever where with without work write \
98 keywords.$(file.patterns.plsql)=\
99 all alter and any array as asc at authid avg begin between \
101 body boolean bulk by char char_base check close cluster collect \
102 comment commit compress connect constant create current currval \
103 cursor date day declare decimal default delete desc distinct \
104 do drop else elsif end exception exclusive execute exists exit \
105 extends false fetch float for forall from function goto group \
106 having heap hour if immediate in index indicator insert integer \
107 interface intersect interval into is isolation java level like \
108 limited lock long loop max min minus minute mlslabel mod mode \
109 month natural naturaln new nextval nocopy not nowait null number \
110 number_base ocirowid of on opaque open operator option or order \
111 organization others out package partition pctfree pls_integer \
112 positive positiven pragma prior private procedure public raise \
113 range raw real record ref release return reverse rollback row \
114 rowid rownum rowtype savepoint second select separate set share \
115 smallint space sql sqlcode sqlerrm start stddev subtype successful \
116 sum synonym sysdate table then time timestamp to trigger true \
117 type uid union unique update use user validate values varchar \
118 varchar2 variance view when whenever where while with work write \