includes/geshi/geshi/oracle8.php

   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.7.6
   8  * CVS Revision Version: $Revision: 1.6 $
   9  * Date Started: 2004/06/04
  10  * Last Modified: $Date: 2005/11/20 07:47:40 $
  11  *
  12  * Oracle 8 language file for GeSHi
  13  *
  14  * CHANGES
  15  * -------
  16  * 2005/01/29 (1.0.0)
  17  *  -  First Release
  18  *
  19  * TODO (updated 2004/11/27)
  20  * -------------------------
  21  *
  22  *************************************************************************************
  23  *
  24  *     This file is part of GeSHi.
  25  *
  26  *   GeSHi is free software; you can redistribute it and/or modify
  27  *   it under the terms of the GNU General Public License as published by
  28  *   the Free Software Foundation; either version 2 of the License, or
  29  *   (at your option) any later version.
  30  *
  31  *   GeSHi is distributed in the hope that it will be useful,
  32  *   but WITHOUT ANY WARRANTY; without even the implied warranty of
  33  *   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  34  *   GNU General Public License for more details.
  35  *
  36  *   You should have received a copy of the GNU General Public License
  37  *   along with GeSHi; if not, write to the Free Software
  38  *   Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
  39  *
  40  ************************************************************************************/
  41
  42 $language_data = array (
  43         'LANG_NAME' => 'Oracle 8',
  44         'COMMENT_SINGLE' => array(1 => '--'),
  45         'COMMENT_MULTI' => array('/*' => '*/'),
  46         'CASE_KEYWORDS' => GESHI_CAPS_UPPER,
  47         'QUOTEMARKS' => array("'", '"', '`'),
  48         'ESCAPE_CHAR' => '\\',
  49         'KEYWORDS' => array(
  50 //Put your package names here - e.g. select distinct ''''|| lower(name) || ''',' from user_source;
  51                 6 => array(
  52                         ),
  53
  54 //Put your table names here - e.g. select distinct ''''|| lower(table_name) || ''',' from user_tables;
  55                 5 => array(
  56                         ),
  57
  58 //Put your view names here - e.g. select distinct ''''|| lower(view_name) || ''',' from user_views;
  59                 4 => array(
  60                         ),
  61
  62 //Put your table field names here - e.g. select distinct ''''|| lower(column_name) || ''',' from user_tab_columns;
  63                 3 => array(
  64                         ),
  65 //Put ORACLE reserved keywords here (8.1.7).  I like mine uppercase.
  66                 1 => array(
  67                         'ABS',
  68                         'ACCESS',
  69                         'ACOS',
  70                         'ADD',
  71                         'ADD_MONTHS',
  72                         'ALL',
  73                         'ALTER',
  74                         'ANALYZE',
  75                         'AND',
  76                         'ANY',
  77                         'ARRAY',
  78                         'AS',
  79                         'ASC',
  80                         'ASCII',
  81                         'ASIN',
  82                         'ASSOCIATE',
  83                         'AT',
  84                         'ATAN',
  85                         'ATAN2',
  86                         'AUDIT',
  87                         'AUTHID',
  88                         'AVG',
  89                         'BEGIN',
  90                         'BETWEEN',
  91                         'BFILENAME',
  92                         'BINARY_INTEGER',
  93                         'BITAND',
  94                         'BODY',
  95                         'BOOLEAN',
  96                         'BULK',
  97                         'BY',
  98                         'CALL',
  99                         'CASCADE',
 100                         'CASE',
 101                         'CEIL',
 102                         'CHAR',
 103                         'CHAR_BASE',
 104                         'CHARTOROWID',
 105                         'CHECK',
 106                         'CHR',
 107                         'CLOSE',
 108                         'CLUSTER',
 109                         'COALESCE',
 110                         'COLLECT',
 111                         'COLUMN',
 112                         'COMMENT',
 113                         'COMMIT',
 114                         'COMPRESS',
 115                         'CONCAT',
 116                         'CONNECT',
 117                         'CONSTANT',
 118                         'CONSTRAINT',
 119                         'CONSTRAINTS',
 120                         'CONTEXT',
 121                         'CONTROLFILE',
 122                         'CONVERT',
 123                         'CORR',
 124                         'COS',
 125                         'COSH',
 126                         'COST',
 127                         'COUNT',
 128                         'COVAR_POP',
 129                         'COVAR_SAMP',
 130                         'CREATE',
 131                         'CUME_DIST',
 132                         'CURRENT',
 133                         'CURRVAL',
 134                         'CURSOR',
 135                         'DATABASE',
 136                         'DATE',
 137                         'DAY',
 138                         'DECIMAL',
 139                         'DECLARE',
 140                         'DECODE',
 141                         'DEFAULT',
 142                         'DELETE',
 143                         'DENSE_RANK',
 144                         'DEREF',
 145                         'DESC',
 146                         'DIMENSION',
 147                         'DIRECTORY',
 148                         'DISASSOCIATE',
 149                         'DISTINCT',
 150                         'DO',
 151                         'DROP',
 152                         'DUMP',
 153                         'ELSE',
 154                         'ELSIF',
 155                         'EMPTY_BLOB',
 156                         'EMPTY_CLOB',
 157                         'END',
 158                         'EXCEPTION',
 159                         'EXCLUSIVE',
 160                         'EXEC',
 161                         'EXECUTE',
 162                         'EXISTS',
 163                         'EXIT',
 164                         'EXP',
 165                         'EXPLAIN',
 166                         'EXTENDS',
 167                         'EXTRACT',
 168                         'FALSE',
 169                         'FETCH',
 170                         'FILE',
 171                         'FIRST_VALUE',
 172                         'FLOAT',
 173                         'FLOOR',
 174                         'FOR',
 175                         'FORALL',
 176                         'FROM',
 177                         'FUNCTION',
 178                         'GOTO',
 179                         'GRANT',
 180                         'GREATEST',
 181                         'GROUP',
 182                         'GROUPING',
 183                         'HAVING',
 184                         'HEAP',
 185                         'HEXTORAW',
 186                         'HOUR',
 187                         'IDENTIFIED',
 188                         'IF',
 189                         'IMMEDIATE',
 190                         'IN',
 191                         'INCREMENT',
 192                         'INDEX',
 193                         'INDEXTYPE',
 194                         'INDICATOR',
 195                         'INITCAP',
 196                         'INITIAL',
 197                         'INSERT',
 198                         'INSTR',
 199                         'INSTRB',
 200                         'INTEGER',
 201                         'INTERFACE',
 202                         'INTERSECT',
 203                         'INTERVAL',
 204                         'INTO',
 205                         'IS',
 206                         'ISOLATION',
 207                         'JAVA',
 208                         'KEY',
 209                         'LAG',
 210                         'LAST_DAY',
 211                         'LAST_VALUE',
 212                         'LEAD',
 213                         'LEAST',
 214                         'LENGTH',
 215                         'LENGTHB',
 216                         'LEVEL',
 217                         'LIBRARY',
 218                         'LIKE',
 219                         'LIMITED',
 220                         'LINK',
 221                         'LN',
 222                         'LOCK',
 223                         'LOG',
 224                         'LONG',
 225                         'LOOP',
 226                         'LOWER',
 227                         'LPAD',
 228                         'LTRIM',
 229                         'MAKE_REF',
 230                         'MATERIALIZED',
 231                         'MAX',
 232                         'MAXEXTENTS',
 233                         'MIN',
 234                         'MINUS',
 235                         'MINUTE',
 236                         'MLSLABEL',
 237                         'MOD',
 238                         'MODE',
 239                         'MODIFY',
 240                         'MONTH',
 241                         'MONTHS_BETWEEN',
 242                         'NATURAL',
 243                         'NATURALN',
 244                         'NEW',
 245                         'NEW_TIME',
 246                         'NEXT_DAY',
 247                         'NEXTVAL',
 248                         'NLS_CHARSET_DECL_LEN',
 249                         'NLS_CHARSET_ID',
 250                         'NLS_CHARSET_NAME',
 251                         'NLS_INITCAP',
 252                         'NLS_LOWER',
 253                         'NLS_UPPER',
 254                         'NLSSORT',
 255                         'NOAUDIT',
 256                         'NOCOMPRESS',
 257                         'NOCOPY',
 258                         'NOT',
 259                         'NOWAIT',
 260                         'NTILE',
 261                         'NULL',
 262                         'NULLIF',
 263                         'NUMBER',
 264                         'NUMBER_BASE',
 265                         'NUMTODSINTERVAL',
 266                         'NUMTOYMINTERVAL',
 267                         'NVL',
 268                         'NVL2',
 269                         'OCIROWID',
 270                         'OF',
 271                         'OFFLINE',
 272                         'ON',
 273                         'ONLINE',
 274                         'OPAQUE',
 275                         'OPEN',
 276                         'OPERATOR',
 277                         'OPTION',
 278                         'OR',
 279                         'ORDER',
 280                         'ORGANIZATION',
 281                         'OTHERS',
 282                         'OUT',
 283                         'OUTLINE',
 284                         'PACKAGE',
 285                         'PARTITION',
 286                         'PCTFREE',
 287                         'PERCENT_RANK',
 288                         'PLAN',
 289                         'PLS_INTEGER',
 290                         'POSITIVE',
 291                         'POSITIVEN',
 292                         'POWER',
 293                         'PRAGMA',
 294                         'PRIMARY',
 295                         'PRIOR',
 296                         'PRIVATE',
 297                         'PRIVILEGES',
 298                         'PROCEDURE',
 299                         'PROFILE',
 300                         'PUBLIC',
 301                         'RAISE',
 302                         'RANGE',
 303                         'RANK',
 304                         'RATIO_TO_REPORT',
 305                         'RAW',
 306                         'RAWTOHEX',
 307                         'REAL',
 308                         'RECORD',
 309                         'REF',
 310                         'REFTOHEX',
 311                         'REGR_AVGX',
 312                         'REGR_AVGY',
 313                         'REGR_COUNT',
 314                         'REGR_INTERCEPT',
 315                         'REGR_R2',
 316                         'REGR_SLOPE',
 317                         'REGR_SXX',
 318                         'REGR_SXY',
 319                         'REGR_SYY',
 320                         'RELEASE',
 321                         'RENAME',
 322                         'REPLACE',
 323                         'RESOURCE',
 324                         'RETURN',
 325                         'RETURNING',
 326                         'REVERSE',
 327                         'REVOKE',
 328                         'ROLE',
 329                         'ROLLBACK',
 330                         'ROUND',
 331                         'ROW',
 332                         'ROW_NUMBER',
 333                         'ROWID',
 334                         'ROWIDTOCHAR',
 335                         'ROWNUM',
 336                         'ROWS',
 337                         'ROWTYPE',
 338                         'RPAD',
 339                         'RTRIM',
 340                         'SAVEPOINT',
 341                         'SCHEMA',
 342                         'SECOND',
 343                         'SEGMENT',
 344                         'SELECT',
 345                         'SEPERATE',
 346                         'SEQUENCE',
 347                         'SESSION',
 348                         'SET',
 349                         'SHARE',
 350                         'SIGN',
 351                         'SIN',
 352                         'SINH',
 353                         'SIZE',
 354                         'SMALLINT',
 355                         'SOUNDEX',
 356                         'SPACE',
 357                         'SQL',
 358                         'SQLCODE',
 359                         'SQLERRM',
 360                         'SQRT',
 361                         'START',
 362                         'STATISTICS',
 363                         'STDDEV',
 364                         'STDDEV_POP',
 365                         'STDDEV_SAMP',
 366                         'STOP',
 367                         'SUBSTR',
 368                         'SUBSTRB',
 369                         'SUBTYPE',
 370                         'SUCCESSFUL',
 371                         'SUM',
 372                         'SYNONYM',
 373                         'SYS_CONTEXT',
 374                         'SYS_GUID',
 375                         'SYSDATE',
 376                         'SYSTEM',
 377                         'TABLE',
 378                         'TABLESPACE',
 379                         'TAN',
 380                         'TANH',
 381                         'TEMPORARY',
 382                         'THEN',
 383                         'TIME',
 384                         'TIMESTAMP',
 385                         'TIMEZONE_ABBR',
 386                         'TIMEZONE_HOUR',
 387                         'TIMEZONE_MINUTE',
 388                         'TIMEZONE_REGION',
 389                         'TIMING',
 390                         'TO',
 391                         'TO_CHAR',
 392                         'TO_DATE',
 393                         'TO_LOB',
 394                         'TO_MULTI_BYTE',
 395                         'TO_NUMBER',
 396                         'TO_SINGLE_BYTE',
 397                         'TRANSACTION',
 398                         'TRANSLATE',
 399                         'TRIGGER',
 400                         'TRIM',
 401                         'TRUE',
 402                         'TRUNC',
 403                         'TRUNCATE',
 404                         'TYPE',
 405                         'UI',
 406                         'UID',
 407                         'UNION',
 408                         'UNIQUE',
 409                         'UPDATE',
 410                         'UPPER',
 411                         'USE',
 412                         'USER',
 413                         'USERENV',
 414                         'USING',
 415                         'VALIDATE',
 416                         'VALUE',
 417                         'VALUES',
 418                         'VAR_POP',
 419                         'VAR_SAMP',
 420                         'VARCHAR',
 421                         'VARCHAR2',
 422                         'VARIANCE',
 423                         'VIEW',
 424                         'VSIZE',
 425                         'WHEN',
 426                         'WHENEVER',
 427                         'WHERE',
 428                         'WHILE',
 429                         'WITH',
 430                         'WORK',
 431                         'WRITE',
 432                         'YEAR',
 433                         'ZONE'
 434                         )
 435                 ),
 436         'SYMBOLS' => array(
 437                 '(', ')', '=', '<', '>', '|'
 438                 ),
 439         'CASE_SENSITIVE' => array(
 440                 GESHI_COMMENTS => false,
 441                 1 => false
 442                 ),
 443         'STYLES' => array(
 444                 'KEYWORDS' => array(
 445                         1 => 'color: #993333; font-weight: bold; text-transform: uppercase;'
 446                         ),
 447                 'COMMENTS' => array(
 448                         1 => 'color: #808080; font-style: italic;',
 449                         2 => 'color: #808080; font-style: italic;'
 450                         ),
 451                 'ESCAPE_CHAR' => array(
 452                         0 => 'color: #000099; font-weight: bold;'
 453                         ),
 454                 'BRACKETS' => array(
 455                         0 => 'color: #66cc66;'
 456                         ),
 457                 'STRINGS' => array(
 458                         0 => 'color: #ff0000;'
 459                         ),
 460                 'NUMBERS' => array(
 461                         0 => 'color: #cc66cc;'
 462                         ),
 463                 'METHODS' => array(
 464                         1 => 'color: #ff0000;'
 465                         ),
 466                 'SYMBOLS' => array(
 467                         0 => 'color: #66cc66;'
 468                         ),
 469                 'SCRIPT' => array(
 470                         ),
 471                 'REGEXPS' => array(
 472                         )
 473                 ),
 474         'URLS' => array(
 475                 ),
 476
 477         'OOLANG' => false,
 478         'OBJECT_SPLITTERS' => array(
 479                 ),
 480         'REGEXPS' => array(
 481                 ),
 482         'STRICT_MODE_APPLIES' => GESHI_NEVER,
 483         'SCRIPT_DELIMITERS' => array(
 484                 ),
 485         'HIGHLIGHT_STRICT_BLOCK' => array(
 486                 )
 487 );
 488
 489 ?>