source: documentation/trunk/packages/dokuwiki-2011-05-25a/inc/geshi/oracle11.php@ 25027

Last change on this file since 25027 was 25027, checked in by jmt12, 12 years ago

Adding the packages directory, and within it a configured version of dokuwiki all ready to run
File size: 15.0 KB
Line 
1<?php
2/*************************************************************************************
3 * oracle11.php
4 * -----------
5 * Author: Guy Wicks ([email protected])
6 * Contributions:
7 * - Updated for 11i by Simon Redhead
8 * Copyright: (c) 2004 Nigel McNie (http://qbnz.com/highlighter)
9 * Release Version: 1.0.8.8
10 * Date Started: 2004/06/04
11 *
12 * Oracle 11i language file for GeSHi.
13 *
14 * CHANGES
15 * -------
16 * 2008/04/08 (1.0.8)
17 * - SR changes to oracle8.php to support Oracle 11i reserved words.
18 * 2005/01/29 (1.0.0)
19 * - First Release
20 *
21 * TODO (updated 2004/11/27)
22 * -------------------------
23 *
24 *************************************************************************************
25 *
26 * This file is part of GeSHi.
27 *
28 * GeSHi is free software; you can redistribute it and/or modify
29 * it under the terms of the GNU General Public License as published by
30 * the Free Software Foundation; either version 2 of the License, or
31 * (at your option) any later version.
32 *
33 * GeSHi is distributed in the hope that it will be useful,
34 * but WITHOUT ANY WARRANTY; without even the implied warranty of
35 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
36 * GNU General Public License for more details.
37 *
38 * You should have received a copy of the GNU General Public License
39 * along with GeSHi; if not, write to the Free Software
40 * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
41 *
42 ************************************************************************************/
43
44$language_data = array (
45 'LANG_NAME' => 'Oracle 11 SQL',
46 'COMMENT_SINGLE' => array(1 => '--'),
47 'COMMENT_MULTI' => array('/*' => '*/'),
48 'CASE_KEYWORDS' => GESHI_CAPS_UPPER,
49 'QUOTEMARKS' => array("'", '"', '`'),
50 'ESCAPE_CHAR' => '\\',
51 'KEYWORDS' => array(
52//Put your package names here - e.g. select distinct ''''|| lower(name) || ''',' from user_source;
53// 6 => array(
54// ),
55
56//Put your table names here - e.g. select distinct ''''|| lower(table_name) || ''',' from user_tables;
57// 5 => array(
58// ),
59
60//Put your view names here - e.g. select distinct ''''|| lower(view_name) || ''',' from user_views;
61// 4 => array(
62// ),
63
64//Put your table field names here - e.g. select distinct ''''|| lower(column_name) || ''',' from user_tab_columns;
65// 3 => array(
66// ),
67
68 //Put ORACLE reserved keywords here (11i). I like mine uppercase.
69 1 => array(
70 'ABS',
71 'ACCESS',
72 'ACOS',
73 'ADD',
74 'ADD_MONTHS',
75 'ALL',
76 'ALTER',
77 'ANALYZE',
78 'AND',
79 'ANY',
80 'APPENDCHILDXML',
81 'ARRAY',
82 'AS',
83 'ASC',
84 'ASCII',
85 'ASCIISTR',
86 'ASIN',
87 'ASSOCIATE',
88 'AT',
89 'ATAN',
90 'ATAN2',
91 'AUDIT',
92 'AUTHID',
93 'AVG',
94 'BEGIN',
95 'BETWEEN',
96 'BFILENAME',
97 'BIN_TO_NUM',
98 'BINARY_INTEGER',
99 'BITAND',
100 'BODY',
101 'BOOLEAN',
102 'BULK',
103 'BY',
104 'CALL',
105 'CARDINALITY',
106 'CASCADE',
107 'CASE',
108 'CAST',
109 'CEIL',
110 'CHAR',
111 'CHAR_BASE',
112 'CHARTOROWID',
113 'CHECK',
114 'CHR',
115 'CLOSE',
116 'CLUSTER',
117 'CLUSTER_ID',
118 'CLUSTER_PROBABILITY',
119 'CLUSTER_SET',
120 'COALESCE',
121 'COLLECT',
122 'COLUMN',
123 'COMMENT',
124 'COMMIT',
125 'COMPOSE',
126 'COMPRESS',
127 'CONCAT',
128 'CONNECT',
129 'CONSTANT',
130 'CONSTRAINT',
131 'CONSTRAINTS',
132 'CONTEXT',
133 'CONTROLFILE',
134 'CONVERT',
135 'CORR',
136 'CORR_K',
137 'CORR_S',
138 'COS',
139 'COSH',
140 'COST',
141 'COUNT',
142 'COVAR_POP',
143 'COVAR_SAMP',
144 'CREATE',
145 'CUBE_TABLE',
146 'CUME_DIST',
147 'CURRENT',
148 'CURRENT_DATE',
149 'CURRENT_TIMESTAMP',
150 'CURRVAL',
151 'CURSOR',
152 'CV',
153 'DATABASE',
154 'DATAOBJ_TO_PARTITION',
155 'DATE',
156 'DAY',
157 'DBTIMEZONE',
158 'DECIMAL',
159 'DECLARE',
160 'DECODE',
161 'DECOMPOSE',
162 'DEFAULT',
163 'DELETE',
164 'DELETEXML',
165 'DENSE_RANK',
166 'DEPTH',
167 'DEREF',
168 'DESC',
169 'DIMENSION',
170 'DIRECTORY',
171 'DISASSOCIATE',
172 'DISTINCT',
173 'DO',
174 'DROP',
175 'DUMP',
176 'ELSE',
177 'ELSIF',
178 'EMPTY_BLOB',
179 'EMPTY_CLOB',
180 'END',
181 'EXCEPTION',
182 'EXCLUSIVE',
183 'EXEC',
184 'EXECUTE',
185 'EXISTS',
186 'EXISTSNODE',
187 'EXIT',
188 'EXP',
189 'EXPLAIN',
190 'EXTENDS',
191 'EXTRACT',
192 'EXTRACTVALUE',
193 'FALSE',
194 'FEATURE_ID',
195 'FEATURE_SET',
196 'FEATURE_VALUE',
197 'FETCH',
198 'FILE',
199 'FIRST',
200 'FIRST_VALUE',
201 'FLOAT',
202 'FLOOR',
203 'FOR',
204 'FORALL',
205 'FROM',
206 'FROM_TZ',
207 'FUNCTION',
208 'GOTO',
209 'GRANT',
210 'GREATEST',
211 'GROUP',
212 'GROUP_ID',
213 'GROUPING',
214 'GROUPING_ID',
215 'HAVING',
216 'HEAP',
217 'HEXTORAW',
218 'HOUR',
219 'IDENTIFIED',
220 'IF',
221 'IMMEDIATE',
222 'IN',
223 'INCREMENT',
224 'INDEX',
225 'INDEXTYPE',
226 'INDICATOR',
227 'INITCAP',
228 'INITIAL',
229 'INSERT',
230 'INSERTCHILDXML',
231 'INSERTXMLBEFORE',
232 'INSTR',
233 'INSTRB',
234 'INTEGER',
235 'INTERFACE',
236 'INTERSECT',
237 'INTERVAL',
238 'INTO',
239 'IS',
240 'ISOLATION',
241 'ITERATION_NUMBER',
242 'JAVA',
243 'KEY',
244 'LAG',
245 'LAST',
246 'LAST_DAY',
247 'LAST_VALUE',
248 'LEAD',
249 'LEAST',
250 'LENGTH',
251 'LENGTHB',
252 'LEVEL',
253 'LIBRARY',
254 'LIKE',
255 'LIMITED',
256 'LINK',
257 'LN',
258 'LNNVL',
259 'LOCALTIMESTAMP',
260 'LOCK',
261 'LOG',
262 'LONG',
263 'LOOP',
264 'LOWER',
265 'LPAD',
266 'LTRIM',
267 'MAKE_REF',
268 'MATERIALIZED',
269 'MAX',
270 'MAXEXTENTS',
271 'MEDIAN',
272 'MIN',
273 'MINUS',
274 'MINUTE',
275 'MLSLABEL',
276 'MOD',
277 'MODE',
278 'MODIFY',
279 'MONTH',
280 'MONTHS_BETWEEN',
281 'NANVL',
282 'NATURAL',
283 'NATURALN',
284 'NCHR',
285 'NEW',
286 'NEW_TIME',
287 'NEXT_DAY',
288 'NEXTVAL',
289 'NLS_CHARSET_DECL_LEN',
290 'NLS_CHARSET_ID',
291 'NLS_CHARSET_NAME',
292 'NLS_INITCAP',
293 'NLS_LOWER',
294 'NLS_UPPER',
295 'NLSSORT',
296 'NOAUDIT',
297 'NOCOMPRESS',
298 'NOCOPY',
299 'NOT',
300 'NOWAIT',
301 'NTILE',
302 'NULL',
303 'NULLIF',
304 'NUMBER',
305 'NUMBER_BASE',
306 'NUMTODSINTERVAL',
307 'NUMTOYMINTERVAL',
308 'NVL',
309 'NVL2',
310 'OCIROWID',
311 'OF',
312 'OFFLINE',
313 'ON',
314 'ONLINE',
315 'OPAQUE',
316 'OPEN',
317 'OPERATOR',
318 'OPTION',
319 'OR',
320 'ORA_HASH',
321 'ORDER',
322 'ORGANIZATION',
323 'OTHERS',
324 'OUT',
325 'OUTLINE',
326 'PACKAGE',
327 'PARTITION',
328 'PATH',
329 'PCTFREE',
330 'PERCENT_RANK',
331 'PERCENTILE_CONT',
332 'PERCENTILE_DISC',
333 'PLAN',
334 'PLS_INTEGER',
335 'POSITIVE',
336 'POSITIVEN',
337 'POWER',
338 'POWERMULTISET',
339 'POWERMULTISET_BY_CARDINALITY',
340 'PRAGMA',
341 'PREDICTION',
342 'PREDICTION_BOUNDS',
343 'PREDICTION_COST',
344 'PREDICTION_DETAILS',
345 'PREDICTION_PROBABILITY',
346 'PREDICTION_SET',
347 'PRESENTNNV',
348 'PRESENTV',
349 'PREVIOUS',
350 'PRIMARY',
351 'PRIOR',
352 'PRIVATE',
353 'PRIVILEGES',
354 'PROCEDURE',
355 'PROFILE',
356 'PUBLIC',
357 'RAISE',
358 'RANGE',
359 'RANK',
360 'RATIO_TO_REPORT',
361 'RAW',
362 'RAWTOHEX',
363 'RAWTONHEX',
364 'REAL',
365 'RECORD',
366 'REF',
367 'REFTOHEX',
368 'REGEXP_COUNT',
369 'REGEXP_INSTR',
370 'REGEXP_REPLACE',
371 'REGEXP_SUBSTR',
372 'REGR_AVGX',
373 'REGR_AVGY',
374 'REGR_COUNT',
375 'REGR_INTERCEPT',
376 'REGR_R2',
377 'REGR_SLOPE',
378 'REGR_SXX',
379 'REGR_SXY',
380 'REGR_SYY',
381 'RELEASE',
382 'REMAINDER',
383 'RENAME',
384 'REPLACE',
385 'RESOURCE',
386 'RETURN',
387 'RETURNING',
388 'REVERSE',
389 'REVOKE',
390 'ROLE',
391 'ROLLBACK',
392 'ROUND',
393 'ROW',
394 'ROW_NUMBER',
395 'ROWID',
396 'ROWIDTOCHAR',
397 'ROWIDTONCHAR',
398 'ROWNUM',
399 'ROWS',
400 'ROWTYPE',
401 'RPAD',
402 'RTRIM',
403 'SAVEPOINT',
404 'SCHEMA',
405 'SCN_TO_TIMESTAMP',
406 'SECOND',
407 'SEGMENT',
408 'SELECT',
409 'SEPERATE',
410 'SEQUENCE',
411 'SESSION',
412 'SESSIONTIMEZONE',
413 'SET',
414 'SHARE',
415 'SIGN',
416 'SIN',
417 'SINH',
418 'SIZE',
419 'SMALLINT',
420 'SOUNDEX',
421 'SPACE',
422 'SQL',
423 'SQLCODE',
424 'SQLERRM',
425 'SQRT',
426 'START',
427 'STATISTICS',
428 'STATS_BINOMIAL_TEST',
429 'STATS_CROSSTAB',
430 'STATS_F_TEST',
431 'STATS_KS_TEST',
432 'STATS_MODE',
433 'STATS_MW_TEST',
434 'STATS_ONE_WAY_ANOVA',
435 'STATS_T_TEST_INDEP',
436 'STATS_T_TEST_INDEPU',
437 'STATS_T_TEST_ONE',
438 'STATS_T_TEST_PAIRED',
439 'STATS_WSR_TEST',
440 'STDDEV',
441 'STDDEV_POP',
442 'STDDEV_SAMP',
443 'STOP',
444 'SUBSTR',
445 'SUBSTRB',
446 'SUBTYPE',
447 'SUCCESSFUL',
448 'SUM',
449 'SYNONYM',
450 'SYS_CONNECT_BY_PATH',
451 'SYS_CONTEXT',
452 'SYS_DBURIGEN',
453 'SYS_EXTRACT_UTC',
454 'SYS_GUID',
455 'SYS_TYPEID',
456 'SYS_XMLAGG',
457 'SYS_XMLGEN',
458 'SYSDATE',
459 'SYSTEM',
460 'SYSTIMESTAMP',
461 'TABLE',
462 'TABLESPACE',
463 'TAN',
464 'TANH',
465 'TEMPORARY',
466 'THEN',
467 'TIME',
468 'TIMESTAMP',
469 'TIMESTAMP_TO_SCN',
470 'TIMEZONE_ABBR',
471 'TIMEZONE_HOUR',
472 'TIMEZONE_MINUTE',
473 'TIMEZONE_REGION',
474 'TIMING',
475 'TO',
476 'TO_BINARY_DOUBLE',
477 'TO_BINARY_FLOAT',
478 'TO_CHAR',
479 'TO_CLOB',
480 'TO_DATE',
481 'TO_DSINTERVAL',
482 'TO_LOB',
483 'TO_MULTI_BYTE',
484 'TO_NCHAR',
485 'TO_NCLOB',
486 'TO_NUMBER',
487 'TO_SINGLE_BYTE',
488 'TO_TIMESTAMP',
489 'TO_TIMESTAMP_TZ',
490 'TO_YMINTERVAL',
491 'TRANSACTION',
492 'TRANSLATE',
493 'TREAT',
494 'TRIGGER',
495 'TRIM',
496 'TRUE',
497 'TRUNC',
498 'TRUNCATE',
499 'TYPE',
500 'TZ_OFFSET',
501 'UI',
502 'UID',
503 'UNION',
504 'UNIQUE',
505 'UNISTR',
506 'UPDATE',
507 'UPDATEXML',
508 'UPPER',
509 'USE',
510 'USER',
511 'USERENV',
512 'USING',
513 'VALIDATE',
514 'VALUE',
515 'VALUES',
516 'VAR_POP',
517 'VAR_SAMP',
518 'VARCHAR',
519 'VARCHAR2',
520 'VARIANCE',
521 'VIEW',
522 'VSIZE',
523 'WHEN',
524 'WHENEVER',
525 'WHERE',
526 'WHILE',
527 'WIDTH_BUCKET',
528 'WITH',
529 'WORK',
530 'WRITE',
531 'XMLAGG',
532 'XMLCAST',
533 'XMLCDATA',
534 'XMLCOLATTVAL',
535 'XMLCOMMENT',
536 'XMLCONCAT',
537 'XMLDIFF',
538 'XMLELEMENT',
539 'XMLEXISTS',
540 'XMLFOREST',
541 'XMLPARSE',
542 'XMLPATCH',
543 'XMLPI',
544 'XMLQUERY',
545 'XMLROOT',
546 'XMLSEQUENCE',
547 'XMLSERIALIZE',
548 'XMLTABLE',
549 'XMLTRANSFORM',
550 'YEAR',
551 'ZONE'
552 )
553 ),
554 'SYMBOLS' => array(
555 '(', ')', '=', '<', '>', '|', '+', '-', '*', '/', ','
556 ),
557 'CASE_SENSITIVE' => array(
558 GESHI_COMMENTS => false,
559 1 => false,
560// 3 => false,
561// 4 => false,
562// 5 => false,
563// 6 => false
564 ),
565 'STYLES' => array(
566 'KEYWORDS' => array(
567 1 => 'color: #993333; font-weight: bold; text-transform: uppercase;'
568 ),
569 'COMMENTS' => array(
570 1 => 'color: #808080; font-style: italic;',
571 ),
572 'ESCAPE_CHAR' => array(
573 0 => 'color: #000099; font-weight: bold;'
574 ),
575 'BRACKETS' => array(
576 0 => 'color: #66cc66;'
577 ),
578 'STRINGS' => array(
579 0 => 'color: #ff0000;'
580 ),
581 'NUMBERS' => array(
582 0 => 'color: #cc66cc;'
583 ),
584 'METHODS' => array(
585 1 => 'color: #ff0000;'
586 ),
587 'SYMBOLS' => array(
588 0 => 'color: #66cc66;'
589 ),
590 'SCRIPT' => array(
591 ),
592 'REGEXPS' => array(
593 )
594 ),
595 'URLS' => array(
596 1 => '',
597// 3 => '',
598// 4 => '',
599// 5 => '',
600// 6 => ''
601 ),
602 'OOLANG' => false,
603 'OBJECT_SPLITTERS' => array(
604 ),
605 'REGEXPS' => array(
606 ),
607 'STRICT_MODE_APPLIES' => GESHI_NEVER,
608 'SCRIPT_DELIMITERS' => array(
609 ),
610 'HIGHLIGHT_STRICT_BLOCK' => array(
611 )
612);
613
614?>
Note: See TracBrowser for help on using the repository browser.