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