| <?php |
| /************************************************************************************* |
| * oracle11.php |
| * ----------- |
| * Author: Guy Wicks (Guy.Wicks@rbs.co.uk) |
| * Contributions: |
| * - Updated for 11i by Simon Redhead |
| * Copyright: (c) 2004 Nigel McNie (http://qbnz.com/highlighter) |
| * Release Version: 1.0.8.3 |
| * Date Started: 2004/06/04 |
| * |
| * Oracle 11i language file for GeSHi. |
| * |
| * CHANGES |
| * ------- |
| * 2008/04/08 (1.0.8) |
| * - SR changes to oracle8.php to support Oracle 11i reserved words. |
| * 2005/01/29 (1.0.0) |
| * - First Release |
| * |
| * TODO (updated 2004/11/27) |
| * ------------------------- |
| * |
| ************************************************************************************* |
| * |
| * This file is part of GeSHi. |
| * |
| * GeSHi is free software; you can redistribute it and/or modify |
| * it under the terms of the GNU General Public License as published by |
| * the Free Software Foundation; either version 2 of the License, or |
| * (at your option) any later version. |
| * |
| * GeSHi is distributed in the hope that it will be useful, |
| * but WITHOUT ANY WARRANTY; without even the implied warranty of |
| * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the |
| * GNU General Public License for more details. |
| * |
| * You should have received a copy of the GNU General Public License |
| * along with GeSHi; if not, write to the Free Software |
| * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA |
| * |
| ************************************************************************************/ |
| |
| $language_data = array ( |
| 'LANG_NAME' => 'Oracle 11 SQL', |
| 'COMMENT_SINGLE' => array(1 => '--'), |
| 'COMMENT_MULTI' => array('/*' => '*/'), |
| 'CASE_KEYWORDS' => GESHI_CAPS_UPPER, |
| 'QUOTEMARKS' => array("'", '"', '`'), |
| 'ESCAPE_CHAR' => '\\', |
| 'KEYWORDS' => array( |
| //Put your package names here - e.g. select distinct ''''|| lower(name) || ''',' from user_source; |
| // 6 => array( |
| // ), |
| |
| //Put your table names here - e.g. select distinct ''''|| lower(table_name) || ''',' from user_tables; |
| // 5 => array( |
| // ), |
| |
| //Put your view names here - e.g. select distinct ''''|| lower(view_name) || ''',' from user_views; |
| // 4 => array( |
| // ), |
| |
| //Put your table field names here - e.g. select distinct ''''|| lower(column_name) || ''',' from user_tab_columns; |
| // 3 => array( |
| // ), |
| |
| //Put ORACLE reserved keywords here (11i). I like mine uppercase. |
| 1 => array( |
| 'ABS', |
| 'ACCESS', |
| 'ACOS', |
| 'ADD', |
| 'ADD_MONTHS', |
| 'ALL', |
| 'ALTER', |
| 'ANALYZE', |
| 'AND', |
| 'ANY', |
| 'APPENDCHILDXML', |
| 'ARRAY', |
| 'AS', |
| 'ASC', |
| 'ASCII', |
| 'ASCIISTR', |
| 'ASIN', |
| 'ASSOCIATE', |
| 'AT', |
| 'ATAN', |
| 'ATAN2', |
| 'AUDIT', |
| 'AUTHID', |
| 'AVG', |
| 'BEGIN', |
| 'BETWEEN', |
| 'BFILENAME', |
| 'BIN_TO_NUM', |
| 'BINARY_INTEGER', |
| 'BITAND', |
| 'BODY', |
| 'BOOLEAN', |
| 'BULK', |
| 'BY', |
| 'CALL', |
| 'CARDINALITY', |
| 'CASCADE', |
| 'CASE', |
| 'CAST', |
| 'CEIL', |
| 'CHAR', |
| 'CHAR_BASE', |
| 'CHARTOROWID', |
| 'CHECK', |
| 'CHR', |
| 'CLOSE', |
| 'CLUSTER', |
| 'CLUSTER_ID', |
| 'CLUSTER_PROBABILITY', |
| 'CLUSTER_SET', |
| 'COALESCE', |
| 'COLLECT', |
| 'COLUMN', |
| 'COMMENT', |
| 'COMMIT', |
| 'COMPOSE', |
| 'COMPRESS', |
| 'CONCAT', |
| 'CONNECT', |
| 'CONSTANT', |
| 'CONSTRAINT', |
| 'CONSTRAINTS', |
| 'CONTEXT', |
| 'CONTROLFILE', |
| 'CONVERT', |
| 'CORR', |
| 'CORR_K', |
| 'CORR_S', |
| 'COS', |
| 'COSH', |
| 'COST', |
| 'COUNT', |
| 'COVAR_POP', |
| 'COVAR_SAMP', |
| 'CREATE', |
| 'CUBE_TABLE', |
| 'CUME_DIST', |
| 'CURRENT', |
| 'CURRENT_DATE', |
| 'CURRENT_TIMESTAMP', |
| 'CURRVAL', |
| 'CURSOR', |
| 'CV', |
| 'DATABASE', |
| 'DATAOBJ_TO_PARTITION', |
| 'DATE', |
| 'DAY', |
| 'DBTIMEZONE', |
| 'DECIMAL', |
| 'DECLARE', |
| 'DECODE', |
| 'DECOMPOSE', |
| 'DEFAULT', |
| 'DELETE', |
| 'DELETEXML', |
| 'DENSE_RANK', |
| 'DEPTH', |
| 'DEREF', |
| 'DESC', |
| 'DIMENSION', |
| 'DIRECTORY', |
| 'DISASSOCIATE', |
| 'DISTINCT', |
| 'DO', |
| 'DROP', |
| 'DUMP', |
| 'ELSE', |
| 'ELSIF', |
| 'EMPTY_BLOB', |
| 'EMPTY_CLOB', |
| 'END', |
| 'EXCEPTION', |
| 'EXCLUSIVE', |
| 'EXEC', |
| 'EXECUTE', |
| 'EXISTS', |
| 'EXISTSNODE', |
| 'EXIT', |
| 'EXP', |
| 'EXPLAIN', |
| 'EXTENDS', |
| 'EXTRACT', |
| 'EXTRACTVALUE', |
| 'FALSE', |
| 'FEATURE_ID', |
| 'FEATURE_SET', |
| 'FEATURE_VALUE', |
| 'FETCH', |
| 'FILE', |
| 'FIRST', |
| 'FIRST_VALUE', |
| 'FLOAT', |
| 'FLOOR', |
| 'FOR', |
| 'FORALL', |
| 'FROM', |
| 'FROM_TZ', |
| 'FUNCTION', |
| 'GOTO', |
| 'GRANT', |
| 'GREATEST', |
| 'GROUP', |
| 'GROUP_ID', |
| 'GROUPING', |
| 'GROUPING_ID', |
| 'HAVING', |
| 'HEAP', |
| 'HEXTORAW', |
| 'HOUR', |
| 'IDENTIFIED', |
| 'IF', |
| 'IMMEDIATE', |
| 'IN', |
| 'INCREMENT', |
| 'INDEX', |
| 'INDEXTYPE', |
| 'INDICATOR', |
| 'INITCAP', |
| 'INITIAL', |
| 'INSERT', |
| 'INSERTCHILDXML', |
| 'INSERTXMLBEFORE', |
| 'INSTR', |
| 'INSTRB', |
| 'INTEGER', |
| 'INTERFACE', |
| 'INTERSECT', |
| 'INTERVAL', |
| 'INTO', |
| 'IS', |
| 'ISOLATION', |
| 'ITERATION_NUMBER', |
| 'JAVA', |
| 'KEY', |
| 'LAG', |
| 'LAST', |
| 'LAST_DAY', |
| 'LAST_VALUE', |
| 'LEAD', |
| 'LEAST', |
| 'LENGTH', |
| 'LENGTHB', |
| 'LEVEL', |
| 'LIBRARY', |
| 'LIKE', |
| 'LIMITED', |
| 'LINK', |
| 'LN', |
| 'LNNVL', |
| 'LOCALTIMESTAMP', |
| 'LOCK', |
| 'LOG', |
| 'LONG', |
| 'LOOP', |
| 'LOWER', |
| 'LPAD', |
| 'LTRIM', |
| 'MAKE_REF', |
| 'MATERIALIZED', |
| 'MAX', |
| 'MAXEXTENTS', |
| 'MEDIAN', |
| 'MIN', |
| 'MINUS', |
| 'MINUTE', |
| 'MLSLABEL', |
| 'MOD', |
| 'MODE', |
| 'MODIFY', |
| 'MONTH', |
| 'MONTHS_BETWEEN', |
| 'NANVL', |
| 'NATURAL', |
| 'NATURALN', |
| 'NCHR', |
| 'NEW', |
| 'NEW_TIME', |
| 'NEXT_DAY', |
| 'NEXTVAL', |
| 'NLS_CHARSET_DECL_LEN', |
| 'NLS_CHARSET_ID', |
| 'NLS_CHARSET_NAME', |
| 'NLS_INITCAP', |
| 'NLS_LOWER', |
| 'NLS_UPPER', |
| 'NLSSORT', |
| 'NOAUDIT', |
| 'NOCOMPRESS', |
| 'NOCOPY', |
| 'NOT', |
| 'NOWAIT', |
| 'NTILE', |
| 'NULL', |
| 'NULLIF', |
| 'NUMBER', |
| 'NUMBER_BASE', |
| 'NUMTODSINTERVAL', |
| 'NUMTOYMINTERVAL', |
| 'NVL', |
| 'NVL2', |
| 'OCIROWID', |
| 'OF', |
| 'OFFLINE', |
| 'ON', |
| 'ONLINE', |
| 'OPAQUE', |
| 'OPEN', |
| 'OPERATOR', |
| 'OPTION', |
| 'OR', |
| 'ORA_HASH', |
| 'ORDER', |
| 'ORGANIZATION', |
| 'OTHERS', |
| 'OUT', |
| 'OUTLINE', |
| 'PACKAGE', |
| 'PARTITION', |
| 'PATH', |
| 'PCTFREE', |
| 'PERCENT_RANK', |
| 'PERCENTILE_CONT', |
| 'PERCENTILE_DISC', |
| 'PLAN', |
| 'PLS_INTEGER', |
| 'POSITIVE', |
| 'POSITIVEN', |
| 'POWER', |
| 'POWERMULTISET', |
| 'POWERMULTISET_BY_CARDINALITY', |
| 'PRAGMA', |
| 'PREDICTION', |
| 'PREDICTION_BOUNDS', |
| 'PREDICTION_COST', |
| 'PREDICTION_DETAILS', |
| 'PREDICTION_PROBABILITY', |
| 'PREDICTION_SET', |
| 'PRESENTNNV', |
| 'PRESENTV', |
| 'PREVIOUS', |
| 'PRIMARY', |
| 'PRIOR', |
| 'PRIVATE', |
| 'PRIVILEGES', |
| 'PROCEDURE', |
| 'PROFILE', |
| 'PUBLIC', |
| 'RAISE', |
| 'RANGE', |
| 'RANK', |
| 'RATIO_TO_REPORT', |
| 'RAW', |
| 'RAWTOHEX', |
| 'RAWTONHEX', |
| 'REAL', |
| 'RECORD', |
| 'REF', |
| 'REFTOHEX', |
| 'REGEXP_COUNT', |
| 'REGEXP_INSTR', |
| 'REGEXP_REPLACE', |
| 'REGEXP_SUBSTR', |
| 'REGR_AVGX', |
| 'REGR_AVGY', |
| 'REGR_COUNT', |
| 'REGR_INTERCEPT', |
| 'REGR_R2', |
| 'REGR_SLOPE', |
| 'REGR_SXX', |
| 'REGR_SXY', |
| 'REGR_SYY', |
| 'RELEASE', |
| 'REMAINDER', |
| 'RENAME', |
| 'REPLACE', |
| 'RESOURCE', |
| 'RETURN', |
| 'RETURNING', |
| 'REVERSE', |
| 'REVOKE', |
| 'ROLE', |
| 'ROLLBACK', |
| 'ROUND', |
| 'ROW', |
| 'ROW_NUMBER', |
| 'ROWID', |
| 'ROWIDTOCHAR', |
| 'ROWIDTONCHAR', |
| 'ROWNUM', |
| 'ROWS', |
| 'ROWTYPE', |
| 'RPAD', |
| 'RTRIM', |
| 'SAVEPOINT', |
| 'SCHEMA', |
| 'SCN_TO_TIMESTAMP', |
| 'SECOND', |
| 'SEGMENT', |
| 'SELECT', |
| 'SEPERATE', |
| 'SEQUENCE', |
| 'SESSION', |
| 'SESSIONTIMEZONE', |
| 'SET', |
| 'SHARE', |
| 'SIGN', |
| 'SIN', |
| 'SINH', |
| 'SIZE', |
| 'SMALLINT', |
| 'SOUNDEX', |
| 'SPACE', |
| 'SQL', |
| 'SQLCODE', |
| 'SQLERRM', |
| 'SQRT', |
| 'START', |
| 'STATISTICS', |
| 'STATS_BINOMIAL_TEST', |
| 'STATS_CROSSTAB', |
| 'STATS_F_TEST', |
| 'STATS_KS_TEST', |
| 'STATS_MODE', |
| 'STATS_MW_TEST', |
| 'STATS_ONE_WAY_ANOVA', |
| 'STATS_T_TEST_INDEP', |
| 'STATS_T_TEST_INDEPU', |
| 'STATS_T_TEST_ONE', |
| 'STATS_T_TEST_PAIRED', |
| 'STATS_WSR_TEST', |
| 'STDDEV', |
| 'STDDEV_POP', |
| 'STDDEV_SAMP', |
| 'STOP', |
| 'SUBSTR', |
| 'SUBSTRB', |
| 'SUBTYPE', |
| 'SUCCESSFUL', |
| 'SUM', |
| 'SYNONYM', |
| 'SYS_CONNECT_BY_PATH', |
| 'SYS_CONTEXT', |
| 'SYS_DBURIGEN', |
| 'SYS_EXTRACT_UTC', |
| 'SYS_GUID', |
| 'SYS_TYPEID', |
| 'SYS_XMLAGG', |
| 'SYS_XMLGEN', |
| 'SYSDATE', |
| 'SYSTEM', |
| 'SYSTIMESTAMP', |
| 'TABLE', |
| 'TABLESPACE', |
| 'TAN', |
| 'TANH', |
| 'TEMPORARY', |
| 'THEN', |
| 'TIME', |
| 'TIMESTAMP', |
| 'TIMESTAMP_TO_SCN', |
| 'TIMEZONE_ABBR', |
| 'TIMEZONE_HOUR', |
| 'TIMEZONE_MINUTE', |
| 'TIMEZONE_REGION', |
| 'TIMING', |
| 'TO', |
| 'TO_BINARY_DOUBLE', |
| 'TO_BINARY_FLOAT', |
| 'TO_CHAR', |
| 'TO_CLOB', |
| 'TO_DATE', |
| 'TO_DSINTERVAL', |
| 'TO_LOB', |
| 'TO_MULTI_BYTE', |
| 'TO_NCHAR', |
| 'TO_NCLOB', |
| 'TO_NUMBER', |
| 'TO_SINGLE_BYTE', |
| 'TO_TIMESTAMP', |
| 'TO_TIMESTAMP_TZ', |
| 'TO_YMINTERVAL', |
| 'TRANSACTION', |
| 'TRANSLATE', |
| 'TREAT', |
| 'TRIGGER', |
| 'TRIM', |
| 'TRUE', |
| 'TRUNC', |
| 'TRUNCATE', |
| 'TYPE', |
| 'TZ_OFFSET', |
| 'UI', |
| 'UID', |
| 'UNION', |
| 'UNIQUE', |
| 'UNISTR', |
| 'UPDATE', |
| 'UPDATEXML', |
| 'UPPER', |
| 'USE', |
| 'USER', |
| 'USERENV', |
| 'USING', |
| 'VALIDATE', |
| 'VALUE', |
| 'VALUES', |
| 'VAR_POP', |
| 'VAR_SAMP', |
| 'VARCHAR', |
| 'VARCHAR2', |
| 'VARIANCE', |
| 'VIEW', |
| 'VSIZE', |
| 'WHEN', |
| 'WHENEVER', |
| 'WHERE', |
| 'WHILE', |
| 'WIDTH_BUCKET', |
| 'WITH', |
| 'WORK', |
| 'WRITE', |
| 'XMLAGG', |
| 'XMLCAST', |
| 'XMLCDATA', |
| 'XMLCOLATTVAL', |
| 'XMLCOMMENT', |
| 'XMLCONCAT', |
| 'XMLDIFF', |
| 'XMLELEMENT', |
| 'XMLEXISTS', |
| 'XMLFOREST', |
| 'XMLPARSE', |
| 'XMLPATCH', |
| 'XMLPI', |
| 'XMLQUERY', |
| 'XMLROOT', |
| 'XMLSEQUENCE', |
| 'XMLSERIALIZE', |
| 'XMLTABLE', |
| 'XMLTRANSFORM', |
| 'YEAR', |
| 'ZONE' |
| ) |
| ), |
| 'SYMBOLS' => array( |
| '(', ')', '=', '<', '>', '|', '+', '-', '*', '/', ',' |
| ), |
| 'CASE_SENSITIVE' => array( |
| GESHI_COMMENTS => false, |
| 1 => false, |
| // 3 => false, |
| // 4 => false, |
| // 5 => false, |
| // 6 => false |
| ), |
| 'STYLES' => array( |
| 'KEYWORDS' => array( |
| 1 => 'color: #993333; font-weight: bold; text-transform: uppercase;' |
| ), |
| 'COMMENTS' => array( |
| 1 => 'color: #808080; font-style: italic;', |
| ), |
| 'ESCAPE_CHAR' => array( |
| 0 => 'color: #000099; font-weight: bold;' |
| ), |
| 'BRACKETS' => array( |
| 0 => 'color: #66cc66;' |
| ), |
| 'STRINGS' => array( |
| 0 => 'color: #ff0000;' |
| ), |
| 'NUMBERS' => array( |
| 0 => 'color: #cc66cc;' |
| ), |
| 'METHODS' => array( |
| 1 => 'color: #ff0000;' |
| ), |
| 'SYMBOLS' => array( |
| 0 => 'color: #66cc66;' |
| ), |
| 'SCRIPT' => array( |
| ), |
| 'REGEXPS' => array( |
| ) |
| ), |
| 'URLS' => array( |
| 1 => '', |
| // 3 => '', |
| // 4 => '', |
| // 5 => '', |
| // 6 => '' |
| ), |
| 'OOLANG' => false, |
| 'OBJECT_SPLITTERS' => array( |
| ), |
| 'REGEXPS' => array( |
| ), |
| 'STRICT_MODE_APPLIES' => GESHI_NEVER, |
| 'SCRIPT_DELIMITERS' => array( |
| ), |
| 'HIGHLIGHT_STRICT_BLOCK' => array( |
| ) |
| ); |
| |
| ?> |