plugins/geshi/geshi/plsql.php
author Dan
Fri, 29 May 2009 19:30:59 -0400
changeset 2 9e3258dfae15
parent 0 441963e5b07a
child 3 f3e2bbbd2155
permissions -rwxr-xr-x
Updated GeSHi. w00t.
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
0
441963e5b07a Initial population - based on GeSHi 1.0.7.20
Dan
parents:
diff changeset
     1
<?php
441963e5b07a Initial population - based on GeSHi 1.0.7.20
Dan
parents:
diff changeset
     2
/*************************************************************************************
441963e5b07a Initial population - based on GeSHi 1.0.7.20
Dan
parents:
diff changeset
     3
 * plsql.php
441963e5b07a Initial population - based on GeSHi 1.0.7.20
Dan
parents:
diff changeset
     4
 * -------
441963e5b07a Initial population - based on GeSHi 1.0.7.20
Dan
parents:
diff changeset
     5
 * Author: Victor Engmark <victor.engmark@gmail.com>
441963e5b07a Initial population - based on GeSHi 1.0.7.20
Dan
parents:
diff changeset
     6
 * Copyright: (c) 2006 Victor Engmark (http://l0b0.net/)
2
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
     7
 * Release Version: 1.0.8.2
0
441963e5b07a Initial population - based on GeSHi 1.0.7.20
Dan
parents:
diff changeset
     8
 * Date Started: 2006/10/26
441963e5b07a Initial population - based on GeSHi 1.0.7.20
Dan
parents:
diff changeset
     9
 *
441963e5b07a Initial population - based on GeSHi 1.0.7.20
Dan
parents:
diff changeset
    10
 * Oracle 9.2 PL/SQL language file for GeSHi.
441963e5b07a Initial population - based on GeSHi 1.0.7.20
Dan
parents:
diff changeset
    11
 * Formatting is based on the default setup of TOAD 8.6.
441963e5b07a Initial population - based on GeSHi 1.0.7.20
Dan
parents:
diff changeset
    12
 *
441963e5b07a Initial population - based on GeSHi 1.0.7.20
Dan
parents:
diff changeset
    13
 * CHANGES
441963e5b07a Initial population - based on GeSHi 1.0.7.20
Dan
parents:
diff changeset
    14
 * -------
441963e5b07a Initial population - based on GeSHi 1.0.7.20
Dan
parents:
diff changeset
    15
 * 2006/10/27 (1.0.0)
2
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
    16
 *    -    First Release
0
441963e5b07a Initial population - based on GeSHi 1.0.7.20
Dan
parents:
diff changeset
    17
 *
441963e5b07a Initial population - based on GeSHi 1.0.7.20
Dan
parents:
diff changeset
    18
 * TODO (updated 2006/10/27)
441963e5b07a Initial population - based on GeSHi 1.0.7.20
Dan
parents:
diff changeset
    19
 * -------------------------
441963e5b07a Initial population - based on GeSHi 1.0.7.20
Dan
parents:
diff changeset
    20
 * * Add < and > to brackets
441963e5b07a Initial population - based on GeSHi 1.0.7.20
Dan
parents:
diff changeset
    21
 * * Remove symbols which are also comment delimiters / quote marks?
441963e5b07a Initial population - based on GeSHi 1.0.7.20
Dan
parents:
diff changeset
    22
 *
441963e5b07a Initial population - based on GeSHi 1.0.7.20
Dan
parents:
diff changeset
    23
 *************************************************************************************
441963e5b07a Initial population - based on GeSHi 1.0.7.20
Dan
parents:
diff changeset
    24
 *
2
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
    25
 *         This file is part of GeSHi.
0
441963e5b07a Initial population - based on GeSHi 1.0.7.20
Dan
parents:
diff changeset
    26
 *
2
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
    27
 *     GeSHi is free software; you can redistribute it and/or modify
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
    28
 *     it under the terms of the GNU General Public License as published by
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
    29
 *     the Free Software Foundation; either version 2 of the License, or
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
    30
 *     (at your option) any later version.
0
441963e5b07a Initial population - based on GeSHi 1.0.7.20
Dan
parents:
diff changeset
    31
 *
2
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
    32
 *     GeSHi is distributed in the hope that it will be useful,
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
    33
 *     but WITHOUT ANY WARRANTY; without even the implied warranty of
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
    34
 *     MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.    See the
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
    35
 *     GNU General Public License for more details.
0
441963e5b07a Initial population - based on GeSHi 1.0.7.20
Dan
parents:
diff changeset
    36
 *
2
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
    37
 *     You should have received a copy of the GNU General Public License
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
    38
 *     along with GeSHi; if not, write to the Free Software
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
    39
 *     Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA    02111-1307    USA
0
441963e5b07a Initial population - based on GeSHi 1.0.7.20
Dan
parents:
diff changeset
    40
 *
441963e5b07a Initial population - based on GeSHi 1.0.7.20
Dan
parents:
diff changeset
    41
 ************************************************************************************/
441963e5b07a Initial population - based on GeSHi 1.0.7.20
Dan
parents:
diff changeset
    42
441963e5b07a Initial population - based on GeSHi 1.0.7.20
Dan
parents:
diff changeset
    43
$language_data = array (
2
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
    44
    'LANG_NAME' => 'PL/SQL',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
    45
    'COMMENT_SINGLE' => array(1 =>'--'), //http://download-uk.oracle.com/docs/cd/B10501_01/appdev.920/a96624/02_funds.htm#2930
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
    46
    'COMMENT_MULTI' => array('/*' => '*/'), //http://download-uk.oracle.com/docs/cd/B10501_01/appdev.920/a96624/02_funds.htm#2950
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
    47
    'CASE_KEYWORDS' => GESHI_CAPS_UPPER,
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
    48
    'QUOTEMARKS' => array("'", '"'), //http://download-uk.oracle.com/docs/cd/B10501_01/appdev.920/a96624/02_funds.htm
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
    49
    'ESCAPE_CHAR' => '\\',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
    50
    'KEYWORDS' => array(
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
    51
        //PL/SQL reserved keywords (http://download-uk.oracle.com/docs/cd/B10501_01/appdev.920/a96624/f_words.htm#LNPLS019)
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
    52
        1 => array('ZONE', 'YEAR', 'WRITE', 'WORK', 'WITH', 'WHILE', 'WHERE',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
    53
        'WHENEVER', 'WHEN', 'VIEW', 'VARCHAR2', 'VARCHAR', 'VALUES',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
    54
        'VALIDATE', 'USE', 'UPDATE', 'UNIQUE', 'UNION', 'TYPE', 'TRUE',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
    55
        'TRIGGER', 'TO', 'TIMEZONE_REGION', 'TIMEZONE_MINUTE', 'TIMEZONE_HOUR',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
    56
        'TIMEZONE_ABBR', 'TIMESTAMP', 'TIME', 'THEN', 'TABLE', 'SYNONYM',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
    57
        'SUCCESSFUL', 'SUBTYPE', 'START', 'SQLERRM', 'SQLCODE', 'SQL', 'SPACE',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
    58
        'SMALLINT', 'SHARE', 'SET', 'SEPARATE', 'SELECT', 'SECOND',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
    59
        'SAVEPOINT', 'ROWTYPE', 'ROWNUM', 'ROWID', 'ROW', 'ROLLBACK',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
    60
        'REVERSE', 'RETURN', 'RELEASE', 'RECORD', 'REAL', 'RAW', 'RANGE',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
    61
        'RAISE', 'PUBLIC', 'PROCEDURE', 'PRIVATE', 'PRIOR', 'PRAGMA',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
    62
        'POSITIVEN', 'POSITIVE', 'PLS_INTEGER', 'PCTFREE', 'PARTITION',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
    63
        'PACKAGE', 'OUT', 'OTHERS', 'ORGANIZATION', 'ORDER', 'OR', 'OPTION',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
    64
        'OPERATOR', 'OPEN', 'OPAQUE', 'ON', 'OF', 'OCIROWID', 'NUMBER_BASE',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
    65
        'NUMBER', 'NULL', 'NOWAIT', 'NOT', 'NOCOPY', 'NEXTVAL', 'NEW',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
    66
        'NATURALN', 'NATURAL', 'MONTH', 'MODE', 'MLSLABEL', 'MINUTE', 'MINUS',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
    67
        'LOOP', 'LONG', 'LOCK', 'LIMITED', 'LIKE', 'LEVEL', 'JAVA',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
    68
        'ISOLATION', 'IS', 'INTO', 'INTERVAL', 'INTERSECT', 'INTERFACE',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
    69
        'INTEGER', 'INSERT', 'INDICATOR', 'INDEX', 'IN', 'IMMEDIATE', 'IF',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
    70
        'HOUR', 'HEAP', 'HAVING', 'GROUP', 'GOTO', 'FUNCTION', 'FROM',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
    71
        'FORALL', 'FOR', 'FLOAT', 'FETCH', 'FALSE', 'EXTENDS', 'EXIT',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
    72
        'EXISTS', 'EXECUTE', 'EXCLUSIVE', 'EXCEPTION', 'END', 'ELSIF', 'ELSE',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
    73
        'DROP', 'DO', 'DISTINCT', 'DESC', 'DELETE', 'DEFAULT', 'DECLARE',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
    74
        'DECIMAL', 'DAY', 'DATE', 'CURSOR', 'CURRVAL', 'CURRENT', 'CREATE',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
    75
        'CONSTANT', 'CONNECT', 'COMPRESS', 'COMMIT', 'COMMENT', 'COLLECT',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
    76
        'CLUSTER', 'CLOSE', 'CHECK', 'CHAR_BASE', 'CHAR', 'CASE', 'BY', 'BULK',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
    77
        'BOOLEAN', 'BODY', 'BINARY_INTEGER', 'BETWEEN', 'BEGIN', 'AUTHID',
0
441963e5b07a Initial population - based on GeSHi 1.0.7.20
Dan
parents:
diff changeset
    78
        'AT', 'ASC', 'AS', 'ARRAY', 'ANY', 'AND', 'ALTER', 'ALL'),
2
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
    79
        //SQL functions (http://download-uk.oracle.com/docs/cd/B10501_01/server.920/a96540/toc.htm & http://download-uk.oracle.com/docs/cd/B10501_01/server.920/a96540/functions101a.htm#85925)
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
    80
        2 => array('XMLTRANSFORM', 'XMLSEQUENCE', 'XMLFOREST', 'XMLELEMENT',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
    81
        'XMLCONCAT', 'XMLCOLATTVAL', 'XMLAGG', 'WIDTH_BUCKET', 'VSIZE',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
    82
        'VARIANCE', 'VAR_SAMP', 'VAR_POP', 'VALUE', 'USERENV', 'USER', 'UPPER',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
    83
        'UPDATEXML', 'UNISTR', 'UID', 'TZ_OFFSET', 'TRUNC', 'TRIM', 'TREAT',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
    84
        'TRANSLATE', 'TO_YMINTERVAL', 'TO_TIMESTAMP_TZ', 'TO_TIMESTAMP',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
    85
        'TO_SINGLE_BYTE', 'TO_NUMBER', 'TO_NCLOB', 'TO_NCHAR', 'TO_MULTI_BYTE',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
    86
        'TO_LOB', 'TO_DSINTERVAL', 'TO_DATE', 'TO_CLOB', 'TO_CHAR', 'TANH',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
    87
        'TAN', 'SYSTIMESTAMP', 'SYSDATE', 'SYS_XMLGEN', 'SYS_XMLAGG',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
    88
        'SYS_TYPEID', 'SYS_GUID', 'SYS_EXTRACT_UTC', 'SYS_DBURIGEN',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
    89
        'SYS_CONTEXT', 'SYS_CONNECT_BY_PATH', 'SUM', 'SUBSTR', 'STDDEV_SAMP',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
    90
        'STDDEV_POP', 'STDDEV', 'SQRT', 'SOUNDEX', 'SINH', 'SIN', 'SIGN',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
    91
        'SESSIONTIMEZONE', 'RTRIM', 'RPAD', 'ROWIDTONCHAR', 'ROWIDTOCHAR',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
    92
        'ROW_NUMBER', 'ROUND', 'REPLACE', 'REGR_SYY', 'REGR_SXY', 'REGR_SXX',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
    93
        'REGR_SLOPE', 'REGR_R2', 'REGR_INTERCEPT', 'REGR_COUNT', 'REGR_AVGY',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
    94
        'REGR_AVGX', 'REFTOHEX', 'REF', 'RAWTONHEX', 'RAWTOHEX',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
    95
        'RATIO_TO_REPORT', 'RANK', 'POWER', 'PERCENTILE_DISC',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
    96
        'PERCENTILE_CONT', 'PERCENT_RANK', 'PATH', 'NVL2', 'NVL',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
    97
        'NUMTOYMINTERVAL', 'NUMTODSINTERVAL', 'NULLIF', 'NTILE', 'NLSSORT',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
    98
        'NLS_UPPER', 'NLS_LOWER', 'NLS_INITCAP', 'NLS_CHARSET_NAME',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
    99
        'NLS_CHARSET_ID', 'NLS_CHARSET_DECL_LEN', 'NEXT_DAY', 'NEW_TIME',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   100
        'NCHR', 'MONTHS_BETWEEN', 'MOD', 'MIN', 'MAX', 'MAKE_REF', 'LTRIM',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   101
        'LPAD', 'LOWER', 'LOG', 'LOCALTIMESTAMP', 'LN', 'LENGTH', 'LEAST',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   102
        'LEAD', 'LAST_VALUE', 'LAST_DAY', 'LAST', 'LAG', 'INSTR', 'INITCAP',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   103
        'HEXTORAW', 'GROUPING_ID', 'GROUPING', 'GROUP_ID', 'GREATEST',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   104
        'FROM_TZ', 'FLOOR', 'FIRST_VALUE', 'FIRST', 'EXTRACTVALUE', 'EXTRACT',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   105
        'EXP', 'EXISTSNODE', 'EMPTY_CLOB', 'EMPTY_BLOB', 'DUMP', 'DEREF',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   106
        'DEPTH', 'DENSE_RANK', 'DECOMPOSE', 'DECODE', 'DBTIMEZONE',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   107
        'CURRENT_TIMESTAMP', 'CURRENT_DATE', 'CUME_DIST', 'COVAR_SAMP',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   108
        'COVAR_POP', 'COUNT', 'COSH', 'COS', 'CORR', 'CONVERT', 'CONCAT',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   109
        'COMPOSE', 'COALESCE', 'CHR', 'CHARTOROWID', 'CEIL', 'CAST', 'BITAND',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   110
        'BIN_TO_NUM', 'BFILENAME', 'AVG', 'ATAN2', 'ATAN', 'ASIN', 'ASCIISTR',
0
441963e5b07a Initial population - based on GeSHi 1.0.7.20
Dan
parents:
diff changeset
   111
        'ASCII', 'ADD_MONTHS', 'ACOS', 'ABS'),
2
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   112
        //PL/SQL packages (http://download-uk.oracle.com/docs/cd/B10501_01/appdev.920/a96612/intro2.htm#1025672)
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   113
        3 => array('UTL_URL', 'UTL_TCP', 'UTL_SMTP', 'UTL_REF', 'UTL_RAW',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   114
        'UTL_PG', 'UTL_INADDR', 'UTL_HTTP', 'UTL_FILE', 'UTL_ENCODE',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   115
        'UTL_COLL', 'SDO_UTIL', 'SDO_TUNE', 'SDO_MIGRATE', 'SDO_LRS',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   116
        'SDO_GEOM', 'SDO_CS', 'DMBS_XMLQUERY', 'DMBS_FLASHBACK',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   117
        'DMBS_DEFER_SYS', 'DEBUG_EXTPROC', 'DBMS_XSLPROCESSOR', 'DBMS_XPLAN',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   118
        'DBMS_XMLSCHEMA', 'DBMS_XMLSAVE', 'DBMS_XMLPARSER', 'DBMS_XMLGEN',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   119
        'DBMS_XMLDOM', 'DBMS_XDBT', 'DBMS_XDB_VERSION', 'DBMS_XDB', 'DBMS_WM',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   120
        'DBMS_UTILITY', 'DBMS_TYPES', 'DBMS_TTS', 'DBMS_TRANSFORM',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   121
        'DBMS_TRANSACTION', 'DBMS_TRACE', 'DBMS_STRM_A', 'DBMS_STRM',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   122
        'DBMS_STORAGE_MAP', 'DBMS_STATS', 'DBMS_SQL', 'DBMS_SPACE_ADMIN',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   123
        'DBMS_SPACE', 'DBMS_SHARED_POOL', 'DBMS_SESSION', 'DBMS_RULE_ADM',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   124
        'DBMS_RULE', 'DBMS_ROWID', 'DBMS_RLS', 'DBMS_RESUMABLE',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   125
        'DBMS_RESOURCE_MANAGER_PRIVS', 'DBMS_RESOURCE_MANAGER', 'DBMS_REPUTIL',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   126
        'DBMS_REPCAT_RGT', 'DBMS_REPCAT_INSTATIATE', 'DBMS_REPCAT_ADMIN',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   127
        'DBMS_REPCAT', 'DBMS_REPAIR', 'DBMS_REFRESH', 'DBMS_REDEFINITION',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   128
        'DBMS_RECTIFIER_DIFF', 'DBMS_RANDOM', 'DBMS_PROPAGATION_ADM',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   129
        'DBMS_PROFILER', 'DBMS_PIPE', 'DBMS_PCLXUTIL', 'DBMS_OUTPUT',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   130
        'DBMS_OUTLN_EDIT', 'DBMS_OUTLN', 'DBMS_ORACLE_TRACE_USER',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   131
        'DBMS_ORACLE_TRACE_AGENT', 'DBMS_OLAP', 'DBMS_OFFLINE_SNAPSHOT',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   132
        'DBMS_OFFLINE_OG', 'DBMS_ODCI', 'DBMS_OBFUSCATION_TOOLKIT',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   133
        'DBMS_MVIEW', 'DBMS_MGWMSG', 'DBMS_MGWADM', 'DBMS_METADATA',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   134
        'DBMS_LOGSTDBY', 'DBMS_LOGMNR_D', 'DBMS_LOGMNR_CDC_SUBSCRIBE',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   135
        'DBMS_LOGMNR_CDC_PUBLISH', 'DBMS_LOGMNR', 'DBMS_LOCK', 'DBMS_LOB',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   136
        'DBMS_LIBCACHE', 'DBMS_LDAP', 'DBMS_JOB', 'DBMS_IOT',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   137
        'DBMS_HS_PASSTHROUGH', 'DBMS_FGA', 'DBMS_DISTRIBUTED_TRUST_ADMIN',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   138
        'DBMS_DESCRIBE', 'DBMS_DEFER_QUERY', 'DBMS_DEFER', 'DBMS_DEBUG',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   139
        'DBMS_DDL', 'DBMS_CAPTURE_ADM', 'DBMS_AW', 'DBMS_AQELM', 'DBMS_AQADM',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   140
        'DBMS_AQ', 'DBMS_APPLY_ADM', 'DBMS_APPLICATION_INFO', 'DBMS_ALERT',
0
441963e5b07a Initial population - based on GeSHi 1.0.7.20
Dan
parents:
diff changeset
   141
        'CWM2_OLAP_AW_ACCESS'),
2
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   142
        //PL/SQL predefined exceptions (http://download-uk.oracle.com/docs/cd/B10501_01/appdev.920/a96624/07_errs.htm#784)
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   143
        4 => array('ZERO_DIVIDE', 'VALUE_ERROR', 'TOO_MANY_ROWS',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   144
        'TIMEOUT_ON_RESOURCE', 'SYS_INVALID_ROWID', 'SUBSCRIPT_OUTSIDE_LIMIT',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   145
        'SUBSCRIPT_BEYOND_COUNT', 'STORAGE_ERROR', 'SELF_IS_NULL',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   146
        'ROWTYPE_MISMATCH', 'PROGRAM_ERROR', 'NOT_LOGGED_ON', 'NO_DATA_FOUND',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   147
        'LOGIN_DENIED', 'INVALID_NUMBER', 'INVALID_CURSOR', 'DUP_VAL_ON_INDEX',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   148
        'CURSOR_ALREADY_OPEN', 'COLLECTION_IS_NULL', 'CASE_NOT_FOUND',
0
441963e5b07a Initial population - based on GeSHi 1.0.7.20
Dan
parents:
diff changeset
   149
        'ACCESS_INTO_NULL'),
2
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   150
        //Static data dictionary views (http://download-uk.oracle.com/docs/cd/B10501_01/server.920/a96536/ch2.htm)
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   151
        5 => array('USER_REPSITES', 'USER_REPSCHEMA',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   152
        'USER_REPRESOLUTION_STATISTICS', 'USER_REPRESOLUTION_METHOD',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   153
        'USER_REPRESOLUTION', 'USER_REPRESOL_STATS_CONTROL', 'USER_REPPROP',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   154
        'USER_REPPRIORITY_GROUP', 'USER_REPPRIORITY',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   155
        'USER_REPPARAMETER_COLUMN', 'USER_REPOBJECT', 'USER_REPKEY_COLUMNS',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   156
        'USER_REPGROUPED_COLUMN', 'USER_REPGROUP_PRIVILEGES', 'USER_REPGROUP',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   157
        'USER_REPGENOBJECTS', 'USER_REPGENERATED', 'USER_REPFLAVORS',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   158
        'USER_REPFLAVOR_OBJECTS', 'USER_REPFLAVOR_COLUMNS', 'USER_REPDDL',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   159
        'USER_REPCONFLICT', 'USER_REPCOLUMN_GROUP', 'USER_REPCOLUMN',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   160
        'USER_REPCATLOG', 'USER_REPCAT_USER_PARM_VALUES',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   161
        'USER_REPCAT_USER_AUTHORIZATIONS', 'USER_REPCAT_TEMPLATE_SITES',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   162
        'USER_REPCAT_TEMPLATE_PARMS', 'USER_REPCAT_TEMPLATE_OBJECTS',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   163
        'USER_REPCAT_REFRESH_TEMPLATES', 'USER_REPCAT', 'USER_REPAUDIT_COLUMN',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   164
        'USER_REPAUDIT_ATTRIBUTE', 'DBA_REPSITES_NEW', 'DBA_REPSITES',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   165
        'DBA_REPSCHEMA', 'DBA_REPRESOLUTION_STATISTICS',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   166
        'DBA_REPRESOLUTION_METHOD', 'DBA_REPRESOLUTION',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   167
        'DBA_REPRESOL_STATS_CONTROL', 'DBA_REPPROP', 'DBA_REPPRIORITY_GROUP',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   168
        'DBA_REPPRIORITY', 'DBA_REPPARAMETER_COLUMN', 'DBA_REPOBJECT',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   169
        'DBA_REPKEY_COLUMNS', 'DBA_REPGROUPED_COLUMN',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   170
        'DBA_REPGROUP_PRIVILEGES', 'DBA_REPGROUP', 'DBA_REPGENOBJECTS',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   171
        'DBA_REPGENERATED', 'DBA_REPFLAVORS', 'DBA_REPFLAVOR_OBJECTS',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   172
        'DBA_REPFLAVOR_COLUMNS', 'DBA_REPEXTENSIONS', 'DBA_REPDDL',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   173
        'DBA_REPCONFLICT', 'DBA_REPCOLUMN_GROUP', 'DBA_REPCOLUMN',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   174
        'DBA_REPCATLOG', 'DBA_REPCAT_USER_PARM_VALUES',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   175
        'DBA_REPCAT_USER_AUTHORIZATIONS', 'DBA_REPCAT_TEMPLATE_SITES',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   176
        'DBA_REPCAT_TEMPLATE_PARMS', 'DBA_REPCAT_TEMPLATE_OBJECTS',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   177
        'DBA_REPCAT_REFRESH_TEMPLATES', 'DBA_REPCAT_EXCEPTIONS', 'DBA_REPCAT',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   178
        'DBA_REPAUDIT_COLUMN', 'DBA_REPAUDIT_ATTRIBUTE', 'ALL_REPSITES',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   179
        'ALL_REPSCHEMA', 'ALL_REPRESOLUTION_STATISTICS',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   180
        'ALL_REPRESOLUTION_METHOD', 'ALL_REPRESOLUTION',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   181
        'ALL_REPRESOL_STATS_CONTROL', 'ALL_REPPROP', 'ALL_REPPRIORITY_GROUP',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   182
        'ALL_REPPRIORITY', 'ALL_REPPARAMETER_COLUMN', 'ALL_REPOBJECT',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   183
        'ALL_REPKEY_COLUMNS', 'ALL_REPGROUPED_COLUMN',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   184
        'ALL_REPGROUP_PRIVILEGES', 'ALL_REPGROUP', 'ALL_REPGENOBJECTS',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   185
        'ALL_REPGENERATED', 'ALL_REPFLAVORS', 'ALL_REPFLAVOR_OBJECTS',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   186
        'ALL_REPFLAVOR_COLUMNS', 'ALL_REPDDL', 'ALL_REPCONFLICT',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   187
        'ALL_REPCOLUMN_GROUP', 'ALL_REPCOLUMN', 'ALL_REPCATLOG',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   188
        'ALL_REPCAT_USER_PARM_VALUES', 'ALL_REPCAT_USER_AUTHORIZATIONS',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   189
        'ALL_REPCAT_TEMPLATE_SITES', 'ALL_REPCAT_TEMPLATE_PARMS',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   190
        'ALL_REPCAT_TEMPLATE_OBJECTS', 'ALL_REPCAT_REFRESH_TEMPLATES',
0
441963e5b07a Initial population - based on GeSHi 1.0.7.20
Dan
parents:
diff changeset
   191
        'ALL_REPCAT', 'ALL_REPAUDIT_COLUMN', 'ALL_REPAUDIT_ATTRIBUTE')
2
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   192
        ),
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   193
    'SYMBOLS' => array(
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   194
        //PL/SQL delimiters (http://download-uk.oracle.com/docs/cd/B10501_01/appdev.920/a96624/02_funds.htm#2732)
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   195
        '+', '%', "'", '.', '/', '(', ')', ':', ',', '*', '"', '=', '<', '>', '@', ';', '-', ':=', '=>', '||', '**', '<<', '>>', '/*', '*/', '..', '<>', '!=', '~=', '^=', '<=', '>='
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   196
        ),
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   197
    'CASE_SENSITIVE' => array(
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   198
        GESHI_COMMENTS => false,
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   199
        1 => false,
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   200
        2 => false,
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   201
        3 => false,
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   202
        4 => false,
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   203
        5 => false
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   204
        ),
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   205
    'STYLES' => array(
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   206
        'KEYWORDS' => array(
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   207
            1 => 'color: #00F;',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   208
            2 => 'color: #000;',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   209
            3 => 'color: #00F;',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   210
            4 => 'color: #F00;',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   211
            5 => 'color: #800;'
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   212
            ),
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   213
        'COMMENTS' => array(
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   214
            1 => 'color: #080; font-style: italic;',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   215
            'MULTI' => 'color: #080; font-style: italic;'
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   216
            ),
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   217
        'ESCAPE_CHAR' => array(
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   218
            0 => 'color: #000; font-weight: bold;'
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   219
            ),
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   220
        'BRACKETS' => array(
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   221
            0 => 'color: #00F;'
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   222
            ),
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   223
        'STRINGS' => array(
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   224
            0 => 'color: #F00;'
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   225
            ),
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   226
        'NUMBERS' => array(
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   227
            0 => 'color: #800;'
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   228
            ),
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   229
        'METHODS' => array(
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   230
            0 => 'color: #0F0;'
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   231
            ),
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   232
        'SYMBOLS' => array(
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   233
            0 => 'color: #00F;'
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   234
            ),
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   235
        'REGEXPS' => array(
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   236
            ),
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   237
        'SCRIPT' => array(
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   238
            0 => 'color: #0F0;'
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   239
            )
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   240
        ),
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   241
        'URLS' => array(
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   242
            1 => 'http://www.oracle.com/pls/db92/db92.drilldown?word={FNAMEU}',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   243
            2 => 'http://www.oracle.com/pls/db92/db92.drilldown?word={FNAMEU}',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   244
            3 => 'http://www.oracle.com/pls/db92/db92.drilldown?word={FNAMEU}',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   245
            4 => 'http://www.oracle.com/pls/db92/db92.drilldown?word={FNAMEU}',
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   246
            5 => 'http://www.oracle.com/pls/db92/db92.drilldown?word={FNAMEU}'
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   247
            ),
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   248
    'OOLANG' => false,
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   249
    'OBJECT_SPLITTERS' => array(),
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   250
    'REGEXPS' => array(),
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   251
    'STRICT_MODE_APPLIES' => GESHI_NEVER,
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   252
    'SCRIPT_DELIMITERS' => array(),
9e3258dfae15 Updated GeSHi. w00t.
Dan
parents: 0
diff changeset
   253
    'HIGHLIGHT_STRICT_BLOCK' => array()
0
441963e5b07a Initial population - based on GeSHi 1.0.7.20
Dan
parents:
diff changeset
   254
);
441963e5b07a Initial population - based on GeSHi 1.0.7.20
Dan
parents:
diff changeset
   255
441963e5b07a Initial population - based on GeSHi 1.0.7.20
Dan
parents:
diff changeset
   256
?>