]> gitweb.factorcode.org Git - factor.git/blob - basis/xmode/modes/pl-sql.xml
b3e084d611fc72e436348c43b9c8554f79003efa
[factor.git] / basis / xmode / modes / pl-sql.xml
1 <?xml version="1.0"?>\r
2 \r
3 <!DOCTYPE MODE SYSTEM "xmode.dtd">\r
4 \r
5 <MODE>\r
6         <PROPS>\r
7                 <PROPERTY NAME="commentStart" VALUE="/*" />\r
8                 <PROPERTY NAME="commentEnd" VALUE="*/" />\r
9                 <PROPERTY NAME="lineComment" VALUE="--" />\r
10         <PROPERTY NAME="indentNextLines" VALUE="\s*(.*THEN|ELSE|LOOP).*" />\r
11                 <PROPERTY NAME="unindentNextLines" VALUE="^\s*(ELSE|ELSIF|END IF|END LOOP).*" />\r
12                 <PROPERTY NAME="unindentThisLine" VALUE="^\s*(ELSE|ELSIF|END IF|END LOOP).*" />\r
13         </PROPS>\r
14         <RULES IGNORE_CASE="TRUE" HIGHLIGHT_DIGITS="TRUE">\r
15                 <SPAN TYPE="LABEL">\r
16                         <BEGIN>/*+</BEGIN>\r
17                         <END>*/</END>\r
18                 </SPAN>\r
19                 <SPAN TYPE="COMMENT1">\r
20                         <BEGIN>/*</BEGIN>\r
21                         <END>*/</END>\r
22                 </SPAN>\r
23                 <SPAN TYPE="LITERAL1">\r
24                         <BEGIN>'</BEGIN>\r
25                         <END>'</END>\r
26                 </SPAN>\r
27                 <SPAN TYPE="LITERAL1">\r
28                         <BEGIN>"</BEGIN>\r
29                         <END>"</END>\r
30                 </SPAN>\r
31                 <SPAN TYPE="LITERAL1" NO_LINE_BREAK="TRUE">\r
32                         <BEGIN>[</BEGIN>\r
33                         <END>]</END>\r
34                 </SPAN>\r
35                 <EOL_SPAN TYPE="LABEL">--+</EOL_SPAN>\r
36                 <EOL_SPAN TYPE="COMMENT1">--</EOL_SPAN>\r
37                 <EOL_SPAN TYPE="COMMENT1" AT_LINE_START="TRUE">REM </EOL_SPAN>\r
38         <EOL_SPAN TYPE="COMMENT1" AT_LINE_START="TRUE">REMARK</EOL_SPAN>\r
39                 <SEQ TYPE="OPERATOR">+</SEQ>\r
40                 <SEQ TYPE="OPERATOR">-</SEQ>\r
41                 <SEQ TYPE="OPERATOR">/</SEQ>\r
42                 <SEQ TYPE="OPERATOR">*</SEQ>\r
43                 <SEQ TYPE="OPERATOR">=</SEQ>\r
44                 <SEQ TYPE="OPERATOR">&gt;</SEQ>\r
45                 <SEQ TYPE="OPERATOR">&lt;</SEQ>\r
46                 <SEQ TYPE="OPERATOR">%</SEQ>\r
47                 <SEQ TYPE="OPERATOR">&amp;</SEQ>\r
48                 <SEQ TYPE="OPERATOR">|</SEQ>\r
49                 <SEQ TYPE="OPERATOR">^</SEQ>\r
50                 <SEQ TYPE="OPERATOR">~</SEQ>\r
51                 <SEQ TYPE="OPERATOR">!=</SEQ>\r
52                 <SEQ TYPE="OPERATOR">!&gt;</SEQ>\r
53                 <SEQ TYPE="OPERATOR">!&lt;</SEQ>\r
54                 <SEQ TYPE="OPERATOR">:=</SEQ>\r
55                 <SEQ TYPE="OPERATOR">.</SEQ>\r
56                 <SEQ TYPE="OPERATOR">(</SEQ>\r
57                 <SEQ TYPE="OPERATOR">)</SEQ>\r
58         <MARK_FOLLOWING AT_LINE_START="TRUE" AT_WHITESPACE_END="TRUE"\r
59                 TYPE="LABEL">@@</MARK_FOLLOWING>\r
60         <MARK_FOLLOWING AT_LINE_START="TRUE"\r
61                 AT_WHITESPACE_END="TRUE" TYPE="LABEL">@</MARK_FOLLOWING>\r
62                 <EOL_SPAN AT_LINE_START="TRUE" DELEGATE="shellscript::MAIN">!</EOL_SPAN>\r
63                 <EOL_SPAN AT_LINE_START="TRUE"\r
64                 DELEGATE="shellscript::MAIN">host</EOL_SPAN>\r
65                 <MARK_PREVIOUS TYPE="LABEL" AT_LINE_START="TRUE">:</MARK_PREVIOUS>\r
66 \r
67                 <KEYWORDS>\r
68                         <!-- reserved words -->\r
69                         <KEYWORD1>ABORT</KEYWORD1>\r
70                         <KEYWORD1>ACCESS</KEYWORD1>\r
71                         <KEYWORD1>ACCEPT</KEYWORD1>\r
72                         <KEYWORD1>ADD</KEYWORD1>\r
73                         <KEYWORD1>ALTER</KEYWORD1>\r
74                         <KEYWORD1>ARRAY</KEYWORD1>\r
75                         <KEYWORD1>ARRAY_LEN</KEYWORD1>\r
76                         <KEYWORD1>AS</KEYWORD1>\r
77                         <KEYWORD1>ASC</KEYWORD1>\r
78                         <KEYWORD1>ASSERT</KEYWORD1>\r
79                         <KEYWORD1>ASSIGN</KEYWORD1>\r
80                         <KEYWORD1>AT</KEYWORD1>\r
81                         <KEYWORD1>AUDIT</KEYWORD1>\r
82                         <KEYWORD1>AUTHORIZATION</KEYWORD1>\r
83                         <KEYWORD1>AVG</KEYWORD1>\r
84                         <KEYWORD1>BASE_TABLE</KEYWORD1>\r
85                         <KEYWORD1>BEGIN</KEYWORD1>\r
86                         <KEYWORD1>BINARY_INTEGER</KEYWORD1>\r
87                         <KEYWORD1>BODY</KEYWORD1>\r
88                         <KEYWORD1>BREAK</KEYWORD1>\r
89                         <KEYWORD1>BREAKS</KEYWORD1>\r
90                         <KEYWORD1>BTITLE</KEYWORD1>\r
91                         <KEYWORD1>CASE</KEYWORD1>\r
92                         <KEYWORD1>CALL</KEYWORD1>\r
93                         <KEYWORD1>CENTER</KEYWORD1>\r
94                         <KEYWORD1>CHAR</KEYWORD1>\r
95                         <KEYWORD1>CHAR_BASE</KEYWORD1>\r
96                         <KEYWORD1>CHECK</KEYWORD1>\r
97                         <KEYWORD1>CLEAR</KEYWORD1>\r
98                         <KEYWORD1>CLOSE</KEYWORD1>\r
99                         <KEYWORD1>CLUSTER</KEYWORD1>\r
100                         <KEYWORD1>CLUSTERS</KEYWORD1>\r
101                         <KEYWORD1>CMPVAR</KEYWORD1>\r
102                         <KEYWORD1>COL</KEYWORD1>\r
103                         <KEYWORD1>COLAUTH</KEYWORD1>\r
104                         <KEYWORD1>COLUMN</KEYWORD1>\r
105                         <KEYWORD1>COLUMNS</KEYWORD1>\r
106                         <KEYWORD1>COMMENT</KEYWORD1>\r
107                         <KEYWORD1>COMMIT</KEYWORD1>\r
108                         <KEYWORD1>COMPRESS</KEYWORD1>\r
109                         <KEYWORD1>COMPUTE</KEYWORD1>\r
110                         <KEYWORD1>CONSTANT</KEYWORD1>\r
111                         <KEYWORD1>CONSTRAINT</KEYWORD1>\r
112                         <KEYWORD1>CONTINUE</KEYWORD1>\r
113                         <KEYWORD1>COUNT</KEYWORD1>\r
114                         <KEYWORD1>CREATE</KEYWORD1>\r
115                         <KEYWORD1>CURRENT</KEYWORD1>\r
116                         <KEYWORD1>CURRVAL</KEYWORD1>\r
117                         <KEYWORD1>CURSOR</KEYWORD1>\r
118                         <KEYWORD1>DATABASE</KEYWORD1>\r
119                         <KEYWORD1>DATA_BASE</KEYWORD1>\r
120                         <KEYWORD1>DATE</KEYWORD1>\r
121                         <KEYWORD1>DBA</KEYWORD1>\r
122                         <KEYWORD1>DEBUGOFF</KEYWORD1>\r
123                         <KEYWORD1>DEBUGON</KEYWORD1>\r
124                         <KEYWORD1>DECLARE</KEYWORD1>\r
125                         <KEYWORD1>DEFAULT</KEYWORD1>\r
126                         <KEYWORD1>DEFINITION</KEYWORD1>\r
127                         <KEYWORD1>DELAY</KEYWORD1>\r
128                         <KEYWORD1>DELETE</KEYWORD1>\r
129                         <KEYWORD1>DESC</KEYWORD1>\r
130                         <KEYWORD1>EXPLAIN</KEYWORD1>\r
131                         <KEYWORD1>DIGITS</KEYWORD1>\r
132                         <KEYWORD1>DISPOSE</KEYWORD1>\r
133                         <KEYWORD1>DISTINCT</KEYWORD1>\r
134                         <KEYWORD1>DO</KEYWORD1>\r
135                         <KEYWORD1>DROP</KEYWORD1>\r
136                         <KEYWORD1>DUMP</KEYWORD1>\r
137                         <KEYWORD1>ELSE</KEYWORD1>\r
138                         <KEYWORD1>ELSIF</KEYWORD1>\r
139                         <KEYWORD1>END</KEYWORD1>\r
140                         <KEYWORD1>ENTRY</KEYWORD1>>\r
141                         <KEYWORD1>ERRORS</KEYWORD1>\r
142                         <KEYWORD1>EXCEPTION</KEYWORD1>\r
143                         <KEYWORD1>EXCEPTION_INIT</KEYWORD1>\r
144                         <KEYWORD1>EXCLUSIVE</KEYWORD1>\r
145                         <KEYWORD1>EXECUTE</KEYWORD1>\r
146                         <KEYWORD1>EXIT</KEYWORD1>\r
147                         <KEYWORD1>EXTERNAL</KEYWORD1>\r
148                         <KEYWORD1>FALSE</KEYWORD1>\r
149                         <KEYWORD1>FETCH</KEYWORD1>\r
150                         <KEYWORD1>FILE</KEYWORD1>\r
151                         <KEYWORD1>FOR</KEYWORD1>\r
152             <KEYWORD1>FOREIGN</KEYWORD1>\r
153                         <KEYWORD1>FORM</KEYWORD1>\r
154                         <KEYWORD1>FORMAT</KEYWORD1>\r
155                         <KEYWORD1>FROM</KEYWORD1>\r
156                         <KEYWORD1>FUNCTION</KEYWORD1>\r
157                         <KEYWORD1>GENERIC</KEYWORD1>\r
158                         <KEYWORD1>GOTO</KEYWORD1>\r
159                         <KEYWORD1>GRANT</KEYWORD1>\r
160                         <KEYWORD1>GREATEST</KEYWORD1>\r
161                         <KEYWORD1>GROUP</KEYWORD1>\r
162                         <KEYWORD1>HAVING</KEYWORD1>\r
163                         <KEYWORD1>HEADING</KEYWORD1>\r
164                         <KEYWORD1>IDENTIFIED</KEYWORD1>\r
165                         <KEYWORD1>IDENTITYCOL</KEYWORD1>\r
166                         <KEYWORD1>IF</KEYWORD1>\r
167                         <KEYWORD1>IMMEDIATE</KEYWORD1>\r
168                         <KEYWORD1>INCREMENT</KEYWORD1>\r
169                         <KEYWORD1>INDEX</KEYWORD1>\r
170                         <KEYWORD1>INDEXES</KEYWORD1>\r
171                         <KEYWORD1>INDICATOR</KEYWORD1>\r
172                         <KEYWORD1>INITIAL</KEYWORD1>\r
173                         <KEYWORD1>INSERT</KEYWORD1>\r
174                         <KEYWORD1>INTERFACE</KEYWORD1>\r
175                         <KEYWORD1>INTO</KEYWORD1>\r
176                         <KEYWORD1>IS</KEYWORD1>\r
177                         <KEYWORD1>KEY</KEYWORD1>\r
178                         <KEYWORD1>LEAST</KEYWORD1>\r
179                         <KEYWORD1>LEVEL</KEYWORD1>\r
180                         <KEYWORD1>LIMITED</KEYWORD1>\r
181                         <KEYWORD1>LOCK</KEYWORD1>\r
182                         <KEYWORD1>LONG</KEYWORD1>\r
183                         <KEYWORD1>LOOP</KEYWORD1>\r
184                         <KEYWORD1>MATCHED</KEYWORD1>\r
185                         <KEYWORD1>MAX</KEYWORD1>\r
186                         <KEYWORD1>MAXEXTENTS</KEYWORD1>\r
187                         <KEYWORD1>MERGE</KEYWORD1>\r
188                         <KEYWORD1>MEMBER</KEYWORD1>\r
189                         <KEYWORD1>MIN</KEYWORD1>\r
190                         <KEYWORD1>MINUS</KEYWORD1>\r
191                         <KEYWORD1>MLSLABEL</KEYWORD1>\r
192                         <KEYWORD1>MOD</KEYWORD1>\r
193                         <KEYWORD1>MODIFY</KEYWORD1>\r
194                         <KEYWORD1>MORE</KEYWORD1>\r
195                         <KEYWORD1>NATURAL</KEYWORD1>\r
196                         <KEYWORD1>NATURALN</KEYWORD1>\r
197                         <KEYWORD1>NEW</KEYWORD1>\r
198                         <KEYWORD1>NEW_VALUE</KEYWORD1>\r
199                         <KEYWORD1>NEXT</KEYWORD1>\r
200                         <KEYWORD1>NEXTVAL</KEYWORD1>\r
201                         <KEYWORD1>NOAUDIT</KEYWORD1>\r
202                         <KEYWORD1>NOCOMPRESS</KEYWORD1>\r
203                         <KEYWORD1>NOPRINT</KEYWORD1>\r
204                         <KEYWORD1>NOWAIT</KEYWORD1>\r
205                         <KEYWORD1>NULL</KEYWORD1>\r
206                         <KEYWORD1>NUMBER</KEYWORD1>\r
207                         <KEYWORD1>NUMBER_BASE</KEYWORD1>\r
208                         <KEYWORD1>OF</KEYWORD1>\r
209                         <KEYWORD1>OFFLINE</KEYWORD1>\r
210                         <KEYWORD1>ON</KEYWORD1>\r
211                         <KEYWORD1>OFF</KEYWORD1>\r
212                         <KEYWORD1>ONLINE</KEYWORD1>\r
213                         <KEYWORD1>OPEN</KEYWORD1>\r
214                         <KEYWORD1>OPTION</KEYWORD1>\r
215                         <KEYWORD1>ORDER</KEYWORD1>\r
216                         <KEYWORD1>ORGANIZATION</KEYWORD1>\r
217                         <KEYWORD1>OTHERS</KEYWORD1>\r
218                         <KEYWORD1>OUT</KEYWORD1>\r
219                         <KEYWORD1>PACKAGE</KEYWORD1>\r
220                         <KEYWORD1>PAGE</KEYWORD1>\r
221                         <KEYWORD1>PARTITION</KEYWORD1>\r
222                         <KEYWORD1>PCTFREE</KEYWORD1>\r
223                         <KEYWORD1>PCTINCREASE</KEYWORD1>\r
224                         <KEYWORD1>PLAN</KEYWORD1>\r
225                         <KEYWORD1>POSITIVE</KEYWORD1>\r
226                         <KEYWORD1>POSITIVEN</KEYWORD1>\r
227                         <KEYWORD1>PRAGMA</KEYWORD1>\r
228                         <KEYWORD1>PRINT</KEYWORD1>\r
229                         <KEYWORD1>PRIMARY</KEYWORD1>\r
230                         <KEYWORD1>PRIOR</KEYWORD1>\r
231                         <KEYWORD1>PRIVATE</KEYWORD1>\r
232                         <KEYWORD1>PRIVILEGES</KEYWORD1>\r
233                         <KEYWORD1>PROCEDURE</KEYWORD1>\r
234                         <KEYWORD1>PROMPT</KEYWORD1>\r
235                         <KEYWORD1>PUBLIC</KEYWORD1>\r
236                         <KEYWORD1>QUOTED_IDENTIFIER</KEYWORD1>\r
237                         <KEYWORD1>RAISE</KEYWORD1>\r
238                         <KEYWORD1>RANGE</KEYWORD1>\r
239                         <KEYWORD1>RAW</KEYWORD1>\r
240                         <KEYWORD1>RECORD</KEYWORD1>\r
241                         <KEYWORD1>REF</KEYWORD1>\r
242             <KEYWORD1>REFERENCES</KEYWORD1>\r
243                         <KEYWORD1>RELEASE</KEYWORD1>\r
244                         <KEYWORD1>REMR</KEYWORD1>\r
245                         <KEYWORD1>RENAME</KEYWORD1>\r
246                         <KEYWORD1>RESOURCE</KEYWORD1>\r
247                         <KEYWORD1>RETURN</KEYWORD1>\r
248                         <KEYWORD1>REVERSE</KEYWORD1>\r
249                         <KEYWORD1>REVOKE</KEYWORD1>\r
250                         <KEYWORD1>ROLLBACK</KEYWORD1>\r
251                         <KEYWORD1>ROW</KEYWORD1>\r
252                         <KEYWORD1>ROWID</KEYWORD1>\r
253                         <KEYWORD1>ROWLABEL</KEYWORD1>\r
254                         <KEYWORD1>ROWNUM</KEYWORD1>\r
255                         <KEYWORD1>ROWS</KEYWORD1>\r
256                         <KEYWORD1>ROWTYPE</KEYWORD1>\r
257                         <KEYWORD1>RUN</KEYWORD1>\r
258                         <KEYWORD1>SAVEPOINT</KEYWORD1>\r
259                         <KEYWORD1>SCHEMA</KEYWORD1>\r
260                         <KEYWORD1>SELECT</KEYWORD1>\r
261                         <KEYWORD1>SEPERATE</KEYWORD1>\r
262                         <KEYWORD1>SEQUENCE</KEYWORD1>\r
263                         <KEYWORD1>SESSION</KEYWORD1>\r
264                         <KEYWORD1>SET</KEYWORD1>\r
265                         <KEYWORD1>SHARE</KEYWORD1>\r
266                         <KEYWORD1>SHOW</KEYWORD1>\r
267                         <KEYWORD1>SIGNTYPE</KEYWORD1>\r
268                         <KEYWORD1>SKIP</KEYWORD1>\r
269                         <KEYWORD1>SPACE</KEYWORD1>\r
270                         <KEYWORD1>SPOOL</KEYWORD1>\r
271                         <NULL>.SQL</NULL> <!-- for 'SPOOL some.sql;' stuff -->\r
272                         <KEYWORD1>SQL</KEYWORD1>\r
273                         <KEYWORD1>SQLCODE</KEYWORD1>\r
274                         <KEYWORD1>SQLERRM</KEYWORD1>\r
275                         <KEYWORD1>SQLERROR</KEYWORD1>\r
276                         <KEYWORD1>STATEMENT</KEYWORD1>\r
277                         <KEYWORD1>STDDEV</KEYWORD1>\r
278                         <KEYWORD1>STORAGE</KEYWORD1>\r
279                         <KEYWORD1>SUBTYPE</KEYWORD1>\r
280                         <KEYWORD1>SUCCESSFULL</KEYWORD1>\r
281                         <KEYWORD1>SUM</KEYWORD1>\r
282                         <KEYWORD1>SYNONYM</KEYWORD1>\r
283                         <KEYWORD1>SYSDATE</KEYWORD1>\r
284                         <KEYWORD1>TABAUTH</KEYWORD1>\r
285                         <KEYWORD1>TABLE</KEYWORD1>\r
286                         <KEYWORD1>TABLES</KEYWORD1>\r
287                         <KEYWORD1>TABLESPACE</KEYWORD1>\r
288                         <KEYWORD1>TASK</KEYWORD1>\r
289                         <KEYWORD1>TERMINATE</KEYWORD1>\r
290                         <KEYWORD1>THEN</KEYWORD1>\r
291                         <KEYWORD1>TO</KEYWORD1>\r
292                         <KEYWORD1>TRIGGER</KEYWORD1>\r
293                         <KEYWORD1>TRUE</KEYWORD1>\r
294                         <KEYWORD1>TRUNCATE</KEYWORD1>\r
295                         <KEYWORD1>TTITLE</KEYWORD1>\r
296                         <KEYWORD1>TYPE</KEYWORD1>\r
297                         <KEYWORD1>UID</KEYWORD1>\r
298                         <KEYWORD1>UNION</KEYWORD1>\r
299                         <KEYWORD1>UNIQUE</KEYWORD1>\r
300                         <KEYWORD1>UNDEFINE</KEYWORD1>\r
301                         <KEYWORD1>UPDATE</KEYWORD1>\r
302                         <KEYWORD1>UPDATETEXT</KEYWORD1>\r
303                         <KEYWORD1>USE</KEYWORD1>\r
304                         <KEYWORD1>USER</KEYWORD1>\r
305                         <KEYWORD1>USING</KEYWORD1>\r
306                         <KEYWORD1>VALIDATE</KEYWORD1>\r
307                         <KEYWORD1>VALUES</KEYWORD1>\r
308                         <KEYWORD1>VARIANCE</KEYWORD1>\r
309                         <KEYWORD1>VIEW</KEYWORD1>\r
310                         <KEYWORD1>VIEWS</KEYWORD1>\r
311                         <KEYWORD1>WHEN</KEYWORD1>\r
312                         <KEYWORD1>WHENEVER</KEYWORD1>\r
313                         <KEYWORD1>WHERE</KEYWORD1>\r
314                         <KEYWORD1>WHILE</KEYWORD1>\r
315                         <KEYWORD1>WITH</KEYWORD1>\r
316                         <KEYWORD1>WORK</KEYWORD1>\r
317                         <KEYWORD1>WRITE</KEYWORD1>\r
318                         <KEYWORD1>XOR</KEYWORD1>\r
319 \r
320                         <!-- data types -->\r
321                         <KEYWORD1>binary</KEYWORD1>\r
322                         <KEYWORD1>bit</KEYWORD1>\r
323                         <KEYWORD1>blob</KEYWORD1>\r
324                         <KEYWORD1>boolean</KEYWORD1>\r
325                         <KEYWORD1>char</KEYWORD1>\r
326                         <KEYWORD1>character</KEYWORD1>\r
327                         <KEYWORD1>datetime</KEYWORD1>\r
328                         <KEYWORD1>decimal</KEYWORD1>\r
329                         <KEYWORD1>float</KEYWORD1>\r
330                         <KEYWORD1>image</KEYWORD1>\r
331                         <KEYWORD1>int</KEYWORD1>\r
332                         <KEYWORD1>integer</KEYWORD1>\r
333                         <KEYWORD1>money</KEYWORD1>\r
334                         <KEYWORD1>numeric</KEYWORD1>\r
335                         <KEYWORD1>nchar</KEYWORD1>\r
336                         <KEYWORD1>nvarchar</KEYWORD1>\r
337                         <KEYWORD1>ntext</KEYWORD1>\r
338                         <KEYWORD1>object</KEYWORD1>\r
339                         <KEYWORD1>pls_integer</KEYWORD1>\r
340                         <KEYWORD1>real</KEYWORD1>\r
341                         <KEYWORD1>smalldatetime</KEYWORD1>\r
342                         <KEYWORD1>smallint</KEYWORD1>\r
343                         <KEYWORD1>smallmoney</KEYWORD1>\r
344                         <KEYWORD1>text</KEYWORD1>\r
345                         <KEYWORD1>timestamp</KEYWORD1>\r
346                         <KEYWORD1>tinyint</KEYWORD1>\r
347                         <KEYWORD1>uniqueidentifier</KEYWORD1>\r
348                         <KEYWORD1>varbinary</KEYWORD1>\r
349                         <KEYWORD1>varchar</KEYWORD1>\r
350                         <KEYWORD1>varchar2</KEYWORD1>\r
351                         <KEYWORD1>varray</KEYWORD1>\r
352 \r
353                         <!-- system functions -->\r
354                         <KEYWORD2>ABS</KEYWORD2>\r
355                         <KEYWORD2>ACOS</KEYWORD2>\r
356                         <KEYWORD2>ADD_MONTHS</KEYWORD2>\r
357                         <KEYWORD2>ASCII</KEYWORD2>\r
358                         <KEYWORD2>ASIN</KEYWORD2>\r
359                         <KEYWORD2>ATAN</KEYWORD2>\r
360                         <KEYWORD2>ATAN2</KEYWORD2>\r
361                         <KEYWORD2>BITAND</KEYWORD2>\r
362                         <KEYWORD2>CEIL</KEYWORD2>\r
363                         <KEYWORD2>CHARTOROWID</KEYWORD2>\r
364                         <KEYWORD2>CHR</KEYWORD2>\r
365                         <KEYWORD2>CONCAT</KEYWORD2>\r
366                         <KEYWORD2>CONVERT</KEYWORD2>\r
367                         <KEYWORD2>COS</KEYWORD2>\r
368                         <KEYWORD2>COSH</KEYWORD2>\r
369                         <KEYWORD2>DECODE</KEYWORD2>\r
370                         <KEYWORD2>DEFINE</KEYWORD2>\r
371                         <KEYWORD2>DUAL</KEYWORD2>\r
372                         <KEYWORD2>FLOOR</KEYWORD2>\r
373                         <KEYWORD2>HEXTORAW</KEYWORD2>\r
374                         <KEYWORD2>INITCAP</KEYWORD2>\r
375                         <KEYWORD2>INSTR</KEYWORD2>\r
376                         <KEYWORD2>INSTRB</KEYWORD2>\r
377                         <KEYWORD2>LAST_DAY</KEYWORD2>\r
378                         <KEYWORD2>LENGTH</KEYWORD2>\r
379                         <KEYWORD2>LENGTHB</KEYWORD2>\r
380                         <KEYWORD2>LN</KEYWORD2>\r
381                         <KEYWORD2>LOG</KEYWORD2>\r
382                         <KEYWORD2>LOWER</KEYWORD2>\r
383                         <KEYWORD2>LPAD</KEYWORD2>\r
384                         <KEYWORD2>LTRIM</KEYWORD2>\r
385                         <KEYWORD2>MOD</KEYWORD2>\r
386                         <KEYWORD2>MONTHS_BETWEEN</KEYWORD2>\r
387                         <KEYWORD2>NEW_TIME</KEYWORD2>\r
388                         <KEYWORD2>NEXT_DAY</KEYWORD2>\r
389                         <KEYWORD2>NLSSORT</KEYWORD2>\r
390                         <KEYWORD2>NSL_INITCAP</KEYWORD2>\r
391                         <KEYWORD2>NLS_LOWER</KEYWORD2>\r
392                         <KEYWORD2>NLS_UPPER</KEYWORD2>\r
393                         <KEYWORD2>NVL</KEYWORD2>\r
394                         <KEYWORD2>POWER</KEYWORD2>\r
395                         <KEYWORD2>RAWTOHEX</KEYWORD2>\r
396                         <KEYWORD2>REPLACE</KEYWORD2>\r
397                         <KEYWORD2>ROUND</KEYWORD2>\r
398                         <KEYWORD2>ROWIDTOCHAR</KEYWORD2>\r
399                         <KEYWORD2>RPAD</KEYWORD2>\r
400                         <KEYWORD2>RTRIM</KEYWORD2>\r
401                         <KEYWORD2>SIGN</KEYWORD2>\r
402                         <KEYWORD2>SOUNDEX</KEYWORD2>\r
403                         <KEYWORD2>SIN</KEYWORD2>\r
404                         <KEYWORD2>SINH</KEYWORD2>\r
405                         <KEYWORD2>SQRT</KEYWORD2>\r
406                         <KEYWORD2>SUBSTR</KEYWORD2>\r
407                         <KEYWORD2>SUBSTRB</KEYWORD2>\r
408                         <KEYWORD2>TAN</KEYWORD2>\r
409                         <KEYWORD2>TANH</KEYWORD2>\r
410                         <KEYWORD2>TO_CHAR</KEYWORD2>\r
411                         <KEYWORD2>TO_DATE</KEYWORD2>\r
412                         <KEYWORD2>TO_MULTIBYTE</KEYWORD2>\r
413                         <KEYWORD2>TO_NUMBER</KEYWORD2>\r
414                         <KEYWORD2>TO_SINGLE_BYTE</KEYWORD2>\r
415                         <KEYWORD2>TRANSLATE</KEYWORD2>\r
416                         <KEYWORD2>TRUNC</KEYWORD2>\r
417                         <KEYWORD2>UPPER</KEYWORD2>\r
418 \r
419                         <!-- operators -->\r
420                         <KEYWORD1>ALL</KEYWORD1>\r
421                         <KEYWORD1>AND</KEYWORD1>\r
422                         <KEYWORD1>ANY</KEYWORD1>\r
423                         <KEYWORD1>BETWEEN</KEYWORD1>\r
424                         <KEYWORD1>BY</KEYWORD1>\r
425                         <KEYWORD1>CONNECT</KEYWORD1>\r
426                         <KEYWORD1>EXISTS</KEYWORD1>\r
427                         <KEYWORD1>IN</KEYWORD1>\r
428                         <KEYWORD1>INTERSECT</KEYWORD1>\r
429                         <KEYWORD1>LIKE</KEYWORD1>\r
430                         <KEYWORD1>NOT</KEYWORD1>\r
431                         <KEYWORD1>NULL</KEYWORD1>\r
432                         <KEYWORD1>OR</KEYWORD1>\r
433                         <KEYWORD1>START</KEYWORD1>\r
434                         <KEYWORD1>UNION</KEYWORD1>\r
435                         <KEYWORD1>WITH</KEYWORD1>\r
436                         <KEYWORD1>NOTFOUND</KEYWORD1>\r
437                         <KEYWORD1>ISOPEN</KEYWORD1>\r
438                         <KEYWORD1>JOIN</KEYWORD1>\r
439                         <KEYWORD1>LEFT</KEYWORD1>\r
440                         <KEYWORD1>RIGHT</KEYWORD1>\r
441                         <KEYWORD1>FULL</KEYWORD1>\r
442                         <KEYWORD1>OUTER</KEYWORD1>\r
443                         <KEYWORD1>CROSS</KEYWORD1>\r
444 \r
445                         <!-- Some common packages -->\r
446                         <KEYWORD3>DBMS_SQL</KEYWORD3>\r
447                         <FUNCTION>OPEN_CURSOR</FUNCTION>\r
448                         <FUNCTION>PARSE</FUNCTION>\r
449                         <FUNCTION>BIND_VARIABLE</FUNCTION>\r
450                         <FUNCTION>BIND_ARRAY</FUNCTION>\r
451                         <FUNCTION>DEFINE_COLUMN</FUNCTION>\r
452                         <FUNCTION>DEFINE_COLUMN_LONG</FUNCTION>\r
453                         <FUNCTION>DEFINE_ARRAY</FUNCTION>\r
454                         <FUNCTION>EXECUTE</FUNCTION>\r
455                         <FUNCTION>FETCH_ROWS</FUNCTION>\r
456                         <FUNCTION>EXECUTE_AND_FETCH</FUNCTION>\r
457                         <FUNCTION>VARIABLE_VALUE</FUNCTION>\r
458                         <FUNCTION>COLUMN_VALUE</FUNCTION>\r
459                         <FUNCTION>COLUMN_VALUE_LONG</FUNCTION>\r
460                         <FUNCTION>CLOSE_CURSOR</FUNCTION>\r
461                         <FUNCTION>DEFINE_COLUMN_CHAR</FUNCTION>\r
462                         <FUNCTION>COLUMN_VALUE_CHAR</FUNCTION>\r
463 \r
464                         <KEYWORD3>DBMS_PROFILER</KEYWORD3>\r
465                         <FUNCTION>START_PROFILER</FUNCTION>\r
466                         <FUNCTION>STOP_PROFILER</FUNCTION>\r
467                         <FUNCTION>ROLLUP_RUN</FUNCTION>\r
468 \r
469                         <!-- other keywords (output-related) -->\r
470                         <KEYWORD3>_EDITOR</KEYWORD3>\r
471                         <KEYWORD3>ARRAYSIZE</KEYWORD3>\r
472                         <KEYWORD3>AUTOTRACE</KEYWORD3>\r
473                         <KEYWORD3>DBMS_OUTPUT</KEYWORD3>\r
474                         <KEYWORD3>ECHO</KEYWORD3>\r
475                         <KEYWORD3>ENABLE</KEYWORD3>\r
476                         <KEYWORD3>FCLOSE</KEYWORD3>\r
477                         <KEYWORD3>FCLOSE_ALL</KEYWORD3>\r
478                         <KEYWORD3>FEED</KEYWORD3>\r
479                         <KEYWORD3>FEEDBACK</KEYWORD3>\r
480                         <KEYWORD3>FILE_TYPE</KEYWORD3>\r
481                         <KEYWORD3>FOPEN</KEYWORD3>\r
482                         <KEYWORD3>HEAD</KEYWORD3>\r
483                         <KEYWORD3>INVALID_OPERATION</KEYWORD3>\r
484                         <KEYWORD3>INVALID_PATH</KEYWORD3>\r
485                         <KEYWORD3>LINESIZE</KEYWORD3>\r
486                         <KEYWORD3>PAGESIZE</KEYWORD3>\r
487                         <KEYWORD3>PAGES</KEYWORD3>\r
488                         <KEYWORD3>PAUSE</KEYWORD3>\r
489                         <KEYWORD3>DOC</KEYWORD3>\r
490                         <KEYWORD3>PUTF</KEYWORD3>\r
491                         <KEYWORD3>PUT_LINE</KEYWORD3>\r
492                         <KEYWORD3>SERVEROUTPUT</KEYWORD3>\r
493                         <KEYWORD3>SQL.PNO</KEYWORD3>\r
494                         <KEYWORD3>UTL_FILE</KEYWORD3>\r
495                         <KEYWORD3>VER</KEYWORD3>\r
496                         <KEYWORD3>VERIFY</KEYWORD3>\r
497                         <KEYWORD3>WRITE_ERROR</KEYWORD3>\r
498                 </KEYWORDS>\r
499         </RULES>\r
500 </MODE>\r
501 \r
502 \r