forked from vidtho/MDT_EditplusDarkTheme
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathidtOracle.stx
162 lines (152 loc) · 1.54 KB
/
idtOracle.stx
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
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
#TITLE=PLSQL
; EditPlus Syntax File written by Sudheer Sankaramaddi, eMail: [email protected]
; This file is provided as a sample syntax file for PL/SQL.
#DELIMITER=,(){}[]-+*%/='"'~!&|\<>?:;.@
#QUOTATION1='
#QUOTATION2="
#CONTINUE_QUOTE=||
#LINECOMMENT=--
#LINECOMMENT2=
#COMMENTON=/*
#COMMENTOFF=*/
#COMMENTON2=
#COMMENTOFF2=
#ESCAPE=
#CASE=n
#PREFIX1=
#PREFIX2=
#PREFIX3=
#PREFIX4=
#PREFIX5=
#SUFFIX1=
#SUFFIX2=
#SUFFIX3=
#SUFFIX4=
#SUFFIX5=
#AUTOCASE=y
#KEYWORD=Yellow
AS
WITH
CASE
WHEN
EXECUTE
IMMEDIATE
THEN
INTO
COMMIT
IN
=
>
<
#KEYWORD=Pink
:
SELECT
INSERT
DELETE
UPDATE
VALUES
SET
ON
WHERE
AND
OR
NOT
CREATE
REPLACE
TABLE
VIEW
INDEX
GRANT
EXCEPTION
PROCEDURE
FUNCTION
BEGIN
DECLARE
#KEYWORD=Blue
DISTINCT
DESC
ASC
UNION
ALL
MINUS
HAVING
NUMBER
DATE
VARCHAR2
CLOB
IDENTITY
#KEYWORD=Orange
COUNT
DECODE
MAX
MIN
NVL
SUBSTR
NULL
SUM
FIRST_VALUE
LAST_VALUE
DENSE_RANK
RANK
LAG
LEAD
LISTAGG
OVER
PARTITION
ORDER
GROUP
BY
;Table properties
CONSTRAINT
CONSTRAINTS
KEY
FOREIGN
PRIMARY
REFERENCES
TABLESPACE
UNIQUE
#KEYWORD=Purple
; Oracle DEFAULTEXCEPTION
ACCESS_INTO_NULL
COLLECTION_IS_NULL
CURSOR_ALREADY_OPEN
DUP_VAL_ON_INDEX
NOT_LOGGED_ON
NO_DATA_FOUND
INVALID_CURSOR
INVALID_NUMBER
LOGIN_DENIED
OTHERS
PROGRAM_ERROR
STORAGE_ERROR
SUBSCRIPT_BEYOND_COUNT
SUBSCRIPT_OUTSIDE_LIMIT
TIMEOUT_ON_RESOURCE
TOO_MANY_ROWS
VALUE_ERROR
ZERO_DIVIDE
; Oracle DEFAULTPACKAGE
DELETING
INSERTING
RAISE_APPLICATION_ERROR
SET_TRANSACTION_USE
UPDATING
; Oracle COMMENT_LINE
REM
REMARK
; Oracle Loops
DO
ELSIF
ELSE
FOR
FORALL
IF
LOOP
WHILE
INNER
OUTER
JOIN
LEFT
RIGHT
FROM
END