diff options
Diffstat (limited to 'paste/include/geshi/oracle11.php')
| -rw-r--r-- | paste/include/geshi/oracle11.php | 614 |
1 files changed, 614 insertions, 0 deletions
diff --git a/paste/include/geshi/oracle11.php b/paste/include/geshi/oracle11.php new file mode 100644 index 0000000..e5417d7 --- /dev/null +++ b/paste/include/geshi/oracle11.php @@ -0,0 +1,614 @@ +<?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.4 + * 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( + ) +); + +?> |