1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
|
# Last changed: Mon Aug 18 1997 Christian Mondrup (reccmo@sc03.sctp.dk)
#
# Last edited:
#
# Mon Aug 18 1997 Christian Mondrup (reccmo@sc03.sctp.dk)
# Added "rem" as comment. Changed case to insensitive.
# Added keywords "define", "spool", "btitle", "ttitle"
style "Oracle SQL-PL/SQL-SQL*Plus" is
written by "Pierre Mareschal <pmaresch@be.oracle.com>"
version is 1.0
documentation is
"18-MAR-97 "
"For comments, support for -- /*..*/ and //."
"This style is to be checked."
end documentation
first alphabet is
"ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz_"
second alphabet is
"ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz_"
case insensitive
keywords in Keyword_strong are
abort, accept, access, add, admin, after, all, allocate, alter,
analyze, and, any, archive, archivelog, array, arraylen, as, asc,
assert, assign, at, audit, authorization, avg, backup, base_table,
become, before, begin, between, binary_integer, block, body,
boolean, btitle, "by", cache, cancel, cascade, "case", change, char,
char_base, character, check, checkpoint, close, cluster, clusters,
cobol, colauth, column, columns, "comment", commit, compile,
compress, connect, constant, constraint, constraints, contents,
continue, controlfile, count, crash, create, current, currval,
cursor, cycle, data_base, database, datafile, date, dba, debugoff,
debugon, dec, decimal, declare, default, define, definition, delay, delete,
delta, desc, digits, disable, dismount, dispose, distinct, do,
double, drop, dump, each, else, elsif, enable, "end", entry,
escape, events, except, exception, exception_init, "exceptions",
exclusive, exec, execute, exists, exit, explain, extent,
externally, false, fetch, file, float, flush, for, force, foreign,
form, fortran, found, freelist, freelists, from, function, generic,
go, goto, grant, group, groups, having, identified, if, immediate,
"in", including, increment, index, indexes, indicator, initial,
initrans, insert, instance, int, integer, interface, intersect,
into, "is", key, language, layer, level, like, limited, link,
lists, lock, logfile, long, loop, manage, manual, max,
maxdatafiles, maxextents, maxinstances, maxlogfiles, maxloghistory,
maxlogmembers, maxtrans, maxvalue, min, minextents, minus,
minvalue, mlslabel, mod, mode, modify, module, mount, natural,
naturaln, new, next, nextval, noarchivelog, noaudit, nocache,
nocompress, nocycle, nomaxvalue, nominvalue, none, noorder,
noresetlogs, normal, nosort, not, notfound, nowait, null, number,
number_base, numeric, of, off, offline, old, on, online, only,
open, optimal, option, or, order, others, out, own, package,
parallel, partition, pctfree, pctincrease, pctused, plan, pli,
pls_integer, positive, positiven, pragma, precision, primary,
prior, private, privileges, procedure, profile, public, quota,
raise, range, raw, read, real, record, recover, ref, references,
referencing, release, remr, rename, resetlogs, resource,
restricted, return, reuse, reverse, revoke, role, roles, rollback,
row, rowid, rowlabel, rownum, rows, rowtype, run, savepoint,
schema, scn, section, segment, select, separate, sequence, session,
set, share, shared, size, smallint, snapshot, some, sort, space, spool,
sql, sqlbuf, sqlcode, sqlerrm, sqlerror, sqlstate, start,
statement, statement_id, statistics, stddev, stop, storage,
subtype, successful, sum, switch, synonym, sysdate, system,
tabauth, table, tables, tablespace, task, temporary, terminate,
then, thread, time, to, tracing, transaction, trigger, triggers,
true, truncate, ttitle, type, uid, under, union, unique, unlimited, until,
update, use, user, using, validate, values, varchar, varchar2,
variance, view, views, when, whenever, where, while, with, work,
write, xor
end keywords
sequences are
"/*+" Comment_strong Comment_strong "*/" Comment_strong,
-- Comment,
rem Comment,
"/*" Comment Comment "*/" Comment,
"//" Comment,
C-string,
C-char
end sequences
end style
|
