javascriptcursus/php/geshi/geshi/oracle11.php

<?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.10 * 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( ) ); ?>

Resultaat

Made by Thijs Aarnoudse