0
|
1 |
<?php
|
|
2 |
/*************************************************************************************
|
|
3 |
* oracle8.php
|
|
4 |
* -----------
|
|
5 |
* Author: Guy Wicks (Guy.Wicks@rbs.co.uk)
|
|
6 |
* Copyright: (c) 2004 Nigel McNie (http://qbnz.com/highlighter)
|
3
|
7 |
* Release Version: 1.0.8.4
|
0
|
8 |
* Date Started: 2004/06/04
|
|
9 |
*
|
2
|
10 |
* Oracle 8 language file for GeSHi.
|
0
|
11 |
*
|
|
12 |
* CHANGES
|
|
13 |
* -------
|
|
14 |
* 2005/01/29 (1.0.0)
|
|
15 |
* - First Release
|
|
16 |
*
|
|
17 |
* TODO (updated 2004/11/27)
|
|
18 |
* -------------------------
|
|
19 |
*
|
|
20 |
*************************************************************************************
|
|
21 |
*
|
|
22 |
* This file is part of GeSHi.
|
|
23 |
*
|
|
24 |
* GeSHi is free software; you can redistribute it and/or modify
|
|
25 |
* it under the terms of the GNU General Public License as published by
|
|
26 |
* the Free Software Foundation; either version 2 of the License, or
|
|
27 |
* (at your option) any later version.
|
|
28 |
*
|
|
29 |
* GeSHi is distributed in the hope that it will be useful,
|
|
30 |
* but WITHOUT ANY WARRANTY; without even the implied warranty of
|
|
31 |
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
|
|
32 |
* GNU General Public License for more details.
|
|
33 |
*
|
|
34 |
* You should have received a copy of the GNU General Public License
|
|
35 |
* along with GeSHi; if not, write to the Free Software
|
|
36 |
* Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
|
|
37 |
*
|
|
38 |
************************************************************************************/
|
|
39 |
|
|
40 |
$language_data = array (
|
2
|
41 |
'LANG_NAME' => 'Oracle 8 SQL',
|
|
42 |
'COMMENT_SINGLE' => array(1 => '--'),
|
|
43 |
'COMMENT_MULTI' => array('/*' => '*/'),
|
|
44 |
'CASE_KEYWORDS' => GESHI_CAPS_UPPER,
|
|
45 |
'QUOTEMARKS' => array("'", '"', '`'),
|
|
46 |
'ESCAPE_CHAR' => '\\',
|
|
47 |
'KEYWORDS' => array(
|
0
|
48 |
//Put your package names here - e.g. select distinct ''''|| lower(name) || ''',' from user_source;
|
2
|
49 |
// 6 => array(
|
|
50 |
// ),
|
0
|
51 |
|
|
52 |
//Put your table names here - e.g. select distinct ''''|| lower(table_name) || ''',' from user_tables;
|
2
|
53 |
// 5 => array(
|
|
54 |
// ),
|
0
|
55 |
|
|
56 |
//Put your view names here - e.g. select distinct ''''|| lower(view_name) || ''',' from user_views;
|
2
|
57 |
// 4 => array(
|
|
58 |
// ),
|
0
|
59 |
|
|
60 |
//Put your table field names here - e.g. select distinct ''''|| lower(column_name) || ''',' from user_tab_columns;
|
2
|
61 |
// 3 => array(
|
|
62 |
// ),
|
|
63 |
|
0
|
64 |
//Put ORACLE reserved keywords here (8.1.7). I like mine uppercase.
|
2
|
65 |
1 => array(
|
|
66 |
'ABS',
|
|
67 |
'ACCESS',
|
|
68 |
'ACOS',
|
|
69 |
'ADD',
|
|
70 |
'ADD_MONTHS',
|
|
71 |
'ALL',
|
|
72 |
'ALTER',
|
|
73 |
'ANALYZE',
|
|
74 |
'AND',
|
|
75 |
'ANY',
|
|
76 |
'ARRAY',
|
|
77 |
'AS',
|
|
78 |
'ASC',
|
|
79 |
'ASCII',
|
|
80 |
'ASIN',
|
|
81 |
'ASSOCIATE',
|
|
82 |
'AT',
|
|
83 |
'ATAN',
|
|
84 |
'ATAN2',
|
|
85 |
'AUDIT',
|
|
86 |
'AUTHID',
|
|
87 |
'AVG',
|
|
88 |
'BEGIN',
|
|
89 |
'BETWEEN',
|
|
90 |
'BFILENAME',
|
|
91 |
'BINARY_INTEGER',
|
|
92 |
'BITAND',
|
|
93 |
'BODY',
|
|
94 |
'BOOLEAN',
|
|
95 |
'BULK',
|
|
96 |
'BY',
|
|
97 |
'CALL',
|
|
98 |
'CASCADE',
|
|
99 |
'CASE',
|
|
100 |
'CEIL',
|
|
101 |
'CHAR',
|
|
102 |
'CHAR_BASE',
|
|
103 |
'CHARTOROWID',
|
|
104 |
'CHECK',
|
|
105 |
'CHR',
|
|
106 |
'CLOSE',
|
|
107 |
'CLUSTER',
|
|
108 |
'COALESCE',
|
|
109 |
'COLLECT',
|
|
110 |
'COLUMN',
|
|
111 |
'COMMENT',
|
|
112 |
'COMMIT',
|
|
113 |
'COMPRESS',
|
|
114 |
'CONCAT',
|
|
115 |
'CONNECT',
|
|
116 |
'CONSTANT',
|
|
117 |
'CONSTRAINT',
|
|
118 |
'CONSTRAINTS',
|
|
119 |
'CONTEXT',
|
|
120 |
'CONTROLFILE',
|
|
121 |
'CONVERT',
|
|
122 |
'CORR',
|
|
123 |
'COS',
|
|
124 |
'COSH',
|
|
125 |
'COST',
|
|
126 |
'COUNT',
|
|
127 |
'COVAR_POP',
|
|
128 |
'COVAR_SAMP',
|
|
129 |
'CREATE',
|
|
130 |
'CUME_DIST',
|
|
131 |
'CURRENT',
|
|
132 |
'CURRVAL',
|
|
133 |
'CURSOR',
|
|
134 |
'DATABASE',
|
|
135 |
'DATE',
|
|
136 |
'DAY',
|
|
137 |
'DECIMAL',
|
|
138 |
'DECLARE',
|
|
139 |
'DECODE',
|
|
140 |
'DEFAULT',
|
|
141 |
'DELETE',
|
|
142 |
'DENSE_RANK',
|
|
143 |
'DEREF',
|
|
144 |
'DESC',
|
|
145 |
'DIMENSION',
|
|
146 |
'DIRECTORY',
|
|
147 |
'DISASSOCIATE',
|
|
148 |
'DISTINCT',
|
|
149 |
'DO',
|
|
150 |
'DROP',
|
|
151 |
'DUMP',
|
|
152 |
'ELSE',
|
|
153 |
'ELSIF',
|
|
154 |
'EMPTY_BLOB',
|
|
155 |
'EMPTY_CLOB',
|
|
156 |
'END',
|
|
157 |
'EXCEPTION',
|
|
158 |
'EXCLUSIVE',
|
|
159 |
'EXEC',
|
|
160 |
'EXECUTE',
|
|
161 |
'EXISTS',
|
|
162 |
'EXIT',
|
|
163 |
'EXP',
|
|
164 |
'EXPLAIN',
|
|
165 |
'EXTENDS',
|
|
166 |
'EXTRACT',
|
|
167 |
'FALSE',
|
|
168 |
'FETCH',
|
|
169 |
'FILE',
|
|
170 |
'FIRST_VALUE',
|
|
171 |
'FLOAT',
|
|
172 |
'FLOOR',
|
|
173 |
'FOR',
|
|
174 |
'FORALL',
|
|
175 |
'FROM',
|
|
176 |
'FUNCTION',
|
|
177 |
'GOTO',
|
|
178 |
'GRANT',
|
|
179 |
'GREATEST',
|
|
180 |
'GROUP',
|
|
181 |
'GROUPING',
|
|
182 |
'HAVING',
|
|
183 |
'HEAP',
|
|
184 |
'HEXTORAW',
|
|
185 |
'HOUR',
|
|
186 |
'IDENTIFIED',
|
|
187 |
'IF',
|
|
188 |
'IMMEDIATE',
|
|
189 |
'IN',
|
|
190 |
'INCREMENT',
|
|
191 |
'INDEX',
|
|
192 |
'INDEXTYPE',
|
|
193 |
'INDICATOR',
|
|
194 |
'INITCAP',
|
|
195 |
'INITIAL',
|
|
196 |
'INSERT',
|
|
197 |
'INSTR',
|
|
198 |
'INSTRB',
|
|
199 |
'INTEGER',
|
|
200 |
'INTERFACE',
|
|
201 |
'INTERSECT',
|
|
202 |
'INTERVAL',
|
|
203 |
'INTO',
|
|
204 |
'IS',
|
|
205 |
'ISOLATION',
|
|
206 |
'JAVA',
|
|
207 |
'KEY',
|
|
208 |
'LAG',
|
|
209 |
'LAST_DAY',
|
|
210 |
'LAST_VALUE',
|
|
211 |
'LEAD',
|
|
212 |
'LEAST',
|
|
213 |
'LENGTH',
|
|
214 |
'LENGTHB',
|
|
215 |
'LEVEL',
|
|
216 |
'LIBRARY',
|
|
217 |
'LIKE',
|
|
218 |
'LIMITED',
|
|
219 |
'LINK',
|
|
220 |
'LN',
|
|
221 |
'LOCK',
|
|
222 |
'LOG',
|
|
223 |
'LONG',
|
|
224 |
'LOOP',
|
|
225 |
'LOWER',
|
|
226 |
'LPAD',
|
|
227 |
'LTRIM',
|
|
228 |
'MAKE_REF',
|
|
229 |
'MATERIALIZED',
|
|
230 |
'MAX',
|
|
231 |
'MAXEXTENTS',
|
|
232 |
'MIN',
|
|
233 |
'MINUS',
|
|
234 |
'MINUTE',
|
|
235 |
'MLSLABEL',
|
|
236 |
'MOD',
|
|
237 |
'MODE',
|
|
238 |
'MODIFY',
|
|
239 |
'MONTH',
|
|
240 |
'MONTHS_BETWEEN',
|
|
241 |
'NATURAL',
|
|
242 |
'NATURALN',
|
|
243 |
'NEW',
|
|
244 |
'NEW_TIME',
|
|
245 |
'NEXT_DAY',
|
|
246 |
'NEXTVAL',
|
|
247 |
'NLS_CHARSET_DECL_LEN',
|
|
248 |
'NLS_CHARSET_ID',
|
|
249 |
'NLS_CHARSET_NAME',
|
|
250 |
'NLS_INITCAP',
|
|
251 |
'NLS_LOWER',
|
|
252 |
'NLS_UPPER',
|
|
253 |
'NLSSORT',
|
|
254 |
'NOAUDIT',
|
|
255 |
'NOCOMPRESS',
|
|
256 |
'NOCOPY',
|
|
257 |
'NOT',
|
|
258 |
'NOWAIT',
|
|
259 |
'NTILE',
|
|
260 |
'NULL',
|
|
261 |
'NULLIF',
|
|
262 |
'NUMBER',
|
|
263 |
'NUMBER_BASE',
|
|
264 |
'NUMTODSINTERVAL',
|
|
265 |
'NUMTOYMINTERVAL',
|
|
266 |
'NVL',
|
|
267 |
'NVL2',
|
|
268 |
'OCIROWID',
|
|
269 |
'OF',
|
|
270 |
'OFFLINE',
|
|
271 |
'ON',
|
|
272 |
'ONLINE',
|
|
273 |
'OPAQUE',
|
|
274 |
'OPEN',
|
|
275 |
'OPERATOR',
|
|
276 |
'OPTION',
|
|
277 |
'OR',
|
|
278 |
'ORDER',
|
|
279 |
'ORGANIZATION',
|
|
280 |
'OTHERS',
|
|
281 |
'OUT',
|
|
282 |
'OUTLINE',
|
|
283 |
'PACKAGE',
|
|
284 |
'PARTITION',
|
|
285 |
'PCTFREE',
|
|
286 |
'PERCENT_RANK',
|
|
287 |
'PLAN',
|
|
288 |
'PLS_INTEGER',
|
|
289 |
'POSITIVE',
|
|
290 |
'POSITIVEN',
|
|
291 |
'POWER',
|
|
292 |
'PRAGMA',
|
|
293 |
'PRIMARY',
|
|
294 |
'PRIOR',
|
|
295 |
'PRIVATE',
|
|
296 |
'PRIVILEGES',
|
|
297 |
'PROCEDURE',
|
|
298 |
'PROFILE',
|
|
299 |
'PUBLIC',
|
|
300 |
'RAISE',
|
|
301 |
'RANGE',
|
|
302 |
'RANK',
|
|
303 |
'RATIO_TO_REPORT',
|
|
304 |
'RAW',
|
|
305 |
'RAWTOHEX',
|
|
306 |
'REAL',
|
|
307 |
'RECORD',
|
|
308 |
'REF',
|
|
309 |
'REFTOHEX',
|
|
310 |
'REGR_AVGX',
|
|
311 |
'REGR_AVGY',
|
|
312 |
'REGR_COUNT',
|
|
313 |
'REGR_INTERCEPT',
|
|
314 |
'REGR_R2',
|
|
315 |
'REGR_SLOPE',
|
|
316 |
'REGR_SXX',
|
|
317 |
'REGR_SXY',
|
|
318 |
'REGR_SYY',
|
|
319 |
'RELEASE',
|
|
320 |
'RENAME',
|
|
321 |
'REPLACE',
|
|
322 |
'RESOURCE',
|
|
323 |
'RETURN',
|
|
324 |
'RETURNING',
|
|
325 |
'REVERSE',
|
|
326 |
'REVOKE',
|
|
327 |
'ROLE',
|
|
328 |
'ROLLBACK',
|
|
329 |
'ROUND',
|
|
330 |
'ROW',
|
|
331 |
'ROW_NUMBER',
|
|
332 |
'ROWID',
|
|
333 |
'ROWIDTOCHAR',
|
|
334 |
'ROWNUM',
|
|
335 |
'ROWS',
|
|
336 |
'ROWTYPE',
|
|
337 |
'RPAD',
|
|
338 |
'RTRIM',
|
|
339 |
'SAVEPOINT',
|
|
340 |
'SCHEMA',
|
|
341 |
'SECOND',
|
|
342 |
'SEGMENT',
|
|
343 |
'SELECT',
|
|
344 |
'SEPERATE',
|
|
345 |
'SEQUENCE',
|
|
346 |
'SESSION',
|
|
347 |
'SET',
|
|
348 |
'SHARE',
|
|
349 |
'SIGN',
|
|
350 |
'SIN',
|
|
351 |
'SINH',
|
|
352 |
'SIZE',
|
|
353 |
'SMALLINT',
|
|
354 |
'SOUNDEX',
|
|
355 |
'SPACE',
|
|
356 |
'SQL',
|
|
357 |
'SQLCODE',
|
|
358 |
'SQLERRM',
|
|
359 |
'SQRT',
|
|
360 |
'START',
|
|
361 |
'STATISTICS',
|
|
362 |
'STDDEV',
|
|
363 |
'STDDEV_POP',
|
|
364 |
'STDDEV_SAMP',
|
|
365 |
'STOP',
|
|
366 |
'SUBSTR',
|
|
367 |
'SUBSTRB',
|
|
368 |
'SUBTYPE',
|
|
369 |
'SUCCESSFUL',
|
|
370 |
'SUM',
|
|
371 |
'SYNONYM',
|
|
372 |
'SYS_CONTEXT',
|
|
373 |
'SYS_GUID',
|
|
374 |
'SYSDATE',
|
|
375 |
'SYSTEM',
|
|
376 |
'TABLE',
|
|
377 |
'TABLESPACE',
|
|
378 |
'TAN',
|
|
379 |
'TANH',
|
|
380 |
'TEMPORARY',
|
|
381 |
'THEN',
|
|
382 |
'TIME',
|
|
383 |
'TIMESTAMP',
|
|
384 |
'TIMEZONE_ABBR',
|
|
385 |
'TIMEZONE_HOUR',
|
|
386 |
'TIMEZONE_MINUTE',
|
|
387 |
'TIMEZONE_REGION',
|
|
388 |
'TIMING',
|
|
389 |
'TO',
|
|
390 |
'TO_CHAR',
|
|
391 |
'TO_DATE',
|
|
392 |
'TO_LOB',
|
|
393 |
'TO_MULTI_BYTE',
|
|
394 |
'TO_NUMBER',
|
|
395 |
'TO_SINGLE_BYTE',
|
|
396 |
'TRANSACTION',
|
|
397 |
'TRANSLATE',
|
|
398 |
'TRIGGER',
|
|
399 |
'TRIM',
|
|
400 |
'TRUE',
|
|
401 |
'TRUNC',
|
|
402 |
'TRUNCATE',
|
|
403 |
'TYPE',
|
|
404 |
'UI',
|
|
405 |
'UID',
|
|
406 |
'UNION',
|
|
407 |
'UNIQUE',
|
|
408 |
'UPDATE',
|
|
409 |
'UPPER',
|
|
410 |
'USE',
|
|
411 |
'USER',
|
|
412 |
'USERENV',
|
|
413 |
'USING',
|
|
414 |
'VALIDATE',
|
|
415 |
'VALUE',
|
|
416 |
'VALUES',
|
|
417 |
'VAR_POP',
|
|
418 |
'VAR_SAMP',
|
|
419 |
'VARCHAR',
|
|
420 |
'VARCHAR2',
|
|
421 |
'VARIANCE',
|
|
422 |
'VIEW',
|
|
423 |
'VSIZE',
|
|
424 |
'WHEN',
|
|
425 |
'WHENEVER',
|
|
426 |
'WHERE',
|
|
427 |
'WHILE',
|
|
428 |
'WITH',
|
|
429 |
'WORK',
|
|
430 |
'WRITE',
|
|
431 |
'YEAR',
|
|
432 |
'ZONE'
|
|
433 |
)
|
|
434 |
),
|
|
435 |
'SYMBOLS' => array(
|
|
436 |
'(', ')', '=', '<', '>', '|', '+', '-', '*', '/', ','
|
|
437 |
),
|
|
438 |
'CASE_SENSITIVE' => array(
|
|
439 |
GESHI_COMMENTS => false,
|
|
440 |
1 => false,
|
|
441 |
// 3 => false,
|
|
442 |
// 4 => false,
|
|
443 |
// 5 => false,
|
|
444 |
// 6 => false
|
|
445 |
),
|
|
446 |
'STYLES' => array(
|
|
447 |
'KEYWORDS' => array(
|
|
448 |
1 => 'color: #993333; font-weight: bold; text-transform: uppercase;'
|
|
449 |
//Add the styles for groups 3-6 here when used
|
|
450 |
),
|
|
451 |
'COMMENTS' => array(
|
|
452 |
1 => 'color: #808080; font-style: italic;'
|
|
453 |
),
|
|
454 |
'ESCAPE_CHAR' => array(
|
|
455 |
0 => 'color: #000099; font-weight: bold;'
|
|
456 |
),
|
|
457 |
'BRACKETS' => array(
|
|
458 |
0 => 'color: #66cc66;'
|
|
459 |
),
|
|
460 |
'STRINGS' => array(
|
|
461 |
0 => 'color: #ff0000;'
|
|
462 |
),
|
|
463 |
'NUMBERS' => array(
|
|
464 |
0 => 'color: #cc66cc;'
|
|
465 |
),
|
|
466 |
'METHODS' => array(
|
|
467 |
1 => 'color: #ff0000;'
|
|
468 |
),
|
|
469 |
'SYMBOLS' => array(
|
|
470 |
0 => 'color: #66cc66;'
|
|
471 |
),
|
|
472 |
'SCRIPT' => array(
|
|
473 |
),
|
|
474 |
'REGEXPS' => array(
|
|
475 |
)
|
|
476 |
),
|
|
477 |
'URLS' => array(
|
|
478 |
1 => '',
|
|
479 |
// 3 => '',
|
|
480 |
// 4 => '',
|
|
481 |
// 5 => '',
|
|
482 |
// 6 => ''
|
|
483 |
),
|
|
484 |
'OOLANG' => false,
|
|
485 |
'OBJECT_SPLITTERS' => array(
|
|
486 |
),
|
|
487 |
'REGEXPS' => array(
|
|
488 |
),
|
|
489 |
'STRICT_MODE_APPLIES' => GESHI_NEVER,
|
|
490 |
'SCRIPT_DELIMITERS' => array(
|
|
491 |
),
|
|
492 |
'HIGHLIGHT_STRICT_BLOCK' => array(
|
|
493 |
)
|
0
|
494 |
);
|
|
495 |
|
|
496 |
?>
|