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)
7 * Release Version: 1.0.9.1
8 * Date Started: 2004/06/04
9 *
10 * Oracle 8 language file for GeSHi.
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 (
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(
48//Put your package names here - e.g. select distinct ''''|| lower(name) || ''',' from user_source;
49//        6 => array(
50//            ),
51
52//Put your table names here - e.g. select distinct ''''|| lower(table_name) || ''',' from user_tables;
53//        5 => array(
54//            ),
55
56//Put your view names here - e.g. select distinct ''''|| lower(view_name) || ''',' from user_views;
57//        4 => array(
58//            ),
59
60//Put your table field names here - e.g. select distinct ''''|| lower(column_name) || ''',' from user_tab_columns;
61//        3 => array(
62//            ),
63
64//Put ORACLE reserved keywords here (8.1.7).  I like mine uppercase.
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        )
494);
495