1<?php 2/************************************************************************************* 3 * oracle11.php 4 * ----------- 5 * Author: Guy Wicks (Guy.Wicks@rbs.co.uk) 6 * Contributions: 7 * - Updated for 11i by Simon Redhead 8 * Copyright: (c) 2004 Nigel McNie (http://qbnz.com/highlighter) 9 * Release Version: 1.0.9.1 10 * Date Started: 2004/06/04 11 * 12 * Oracle 11i language file for GeSHi. 13 * 14 * CHANGES 15 * ------- 16 * 2008/04/08 (1.0.8) 17 * - SR changes to oracle8.php to support Oracle 11i reserved words. 18 * 2005/01/29 (1.0.0) 19 * - First Release 20 * 21 * TODO (updated 2004/11/27) 22 * ------------------------- 23 * 24 ************************************************************************************* 25 * 26 * This file is part of GeSHi. 27 * 28 * GeSHi is free software; you can redistribute it and/or modify 29 * it under the terms of the GNU General Public License as published by 30 * the Free Software Foundation; either version 2 of the License, or 31 * (at your option) any later version. 32 * 33 * GeSHi is distributed in the hope that it will be useful, 34 * but WITHOUT ANY WARRANTY; without even the implied warranty of 35 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 36 * GNU General Public License for more details. 37 * 38 * You should have received a copy of the GNU General Public License 39 * along with GeSHi; if not, write to the Free Software 40 * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA 41 * 42 ************************************************************************************/ 43 44$language_data = array ( 45 'LANG_NAME' => 'Oracle 11 SQL', 46 'COMMENT_SINGLE' => array(1 => '--'), 47 'COMMENT_MULTI' => array('/*' => '*/'), 48 'CASE_KEYWORDS' => GESHI_CAPS_UPPER, 49 'QUOTEMARKS' => array("'", '"', '`'), 50 'ESCAPE_CHAR' => '\\', 51 'KEYWORDS' => array( 52//Put your package names here - e.g. select distinct ''''|| lower(name) || ''',' from user_source; 53// 6 => array( 54// ), 55 56//Put your table names here - e.g. select distinct ''''|| lower(table_name) || ''',' from user_tables; 57// 5 => array( 58// ), 59 60//Put your view names here - e.g. select distinct ''''|| lower(view_name) || ''',' from user_views; 61// 4 => array( 62// ), 63 64//Put your table field names here - e.g. select distinct ''''|| lower(column_name) || ''',' from user_tab_columns; 65// 3 => array( 66// ), 67 68 //Put ORACLE reserved keywords here (11i). I like mine uppercase. 69 1 => array( 70 'ABS', 71 'ACCESS', 72 'ACOS', 73 'ADD', 74 'ADD_MONTHS', 75 'ALL', 76 'ALTER', 77 'ANALYZE', 78 'AND', 79 'ANY', 80 'APPENDCHILDXML', 81 'ARRAY', 82 'AS', 83 'ASC', 84 'ASCII', 85 'ASCIISTR', 86 'ASIN', 87 'ASSOCIATE', 88 'AT', 89 'ATAN', 90 'ATAN2', 91 'AUDIT', 92 'AUTHID', 93 'AVG', 94 'BEGIN', 95 'BETWEEN', 96 'BFILENAME', 97 'BIN_TO_NUM', 98 'BINARY_INTEGER', 99 'BITAND', 100 'BODY', 101 'BOOLEAN', 102 'BULK', 103 'BY', 104 'CALL', 105 'CARDINALITY', 106 'CASCADE', 107 'CASE', 108 'CAST', 109 'CEIL', 110 'CHAR', 111 'CHAR_BASE', 112 'CHARTOROWID', 113 'CHECK', 114 'CHR', 115 'CLOSE', 116 'CLUSTER', 117 'CLUSTER_ID', 118 'CLUSTER_PROBABILITY', 119 'CLUSTER_SET', 120 'COALESCE', 121 'COLLECT', 122 'COLUMN', 123 'COMMENT', 124 'COMMIT', 125 'COMPOSE', 126 'COMPRESS', 127 'CONCAT', 128 'CONNECT', 129 'CONSTANT', 130 'CONSTRAINT', 131 'CONSTRAINTS', 132 'CONTEXT', 133 'CONTROLFILE', 134 'CONVERT', 135 'CORR', 136 'CORR_K', 137 'CORR_S', 138 'COS', 139 'COSH', 140 'COST', 141 'COUNT', 142 'COVAR_POP', 143 'COVAR_SAMP', 144 'CREATE', 145 'CUBE_TABLE', 146 'CUME_DIST', 147 'CURRENT', 148 'CURRENT_DATE', 149 'CURRENT_TIMESTAMP', 150 'CURRVAL', 151 'CURSOR', 152 'CV', 153 'DATABASE', 154 'DATAOBJ_TO_PARTITION', 155 'DATE', 156 'DAY', 157 'DBTIMEZONE', 158 'DECIMAL', 159 'DECLARE', 160 'DECODE', 161 'DECOMPOSE', 162 'DEFAULT', 163 'DELETE', 164 'DELETEXML', 165 'DENSE_RANK', 166 'DEPTH', 167 'DEREF', 168 'DESC', 169 'DIMENSION', 170 'DIRECTORY', 171 'DISASSOCIATE', 172 'DISTINCT', 173 'DO', 174 'DROP', 175 'DUMP', 176 'ELSE', 177 'ELSIF', 178 'EMPTY_BLOB', 179 'EMPTY_CLOB', 180 'END', 181 'EXCEPTION', 182 'EXCLUSIVE', 183 'EXEC', 184 'EXECUTE', 185 'EXISTS', 186 'EXISTSNODE', 187 'EXIT', 188 'EXP', 189 'EXPLAIN', 190 'EXTENDS', 191 'EXTRACT', 192 'EXTRACTVALUE', 193 'FALSE', 194 'FEATURE_ID', 195 'FEATURE_SET', 196 'FEATURE_VALUE', 197 'FETCH', 198 'FILE', 199 'FIRST', 200 'FIRST_VALUE', 201 'FLOAT', 202 'FLOOR', 203 'FOR', 204 'FORALL', 205 'FROM', 206 'FROM_TZ', 207 'FUNCTION', 208 'GOTO', 209 'GRANT', 210 'GREATEST', 211 'GROUP', 212 'GROUP_ID', 213 'GROUPING', 214 'GROUPING_ID', 215 'HAVING', 216 'HEAP', 217 'HEXTORAW', 218 'HOUR', 219 'IDENTIFIED', 220 'IF', 221 'IMMEDIATE', 222 'IN', 223 'INCREMENT', 224 'INDEX', 225 'INDEXTYPE', 226 'INDICATOR', 227 'INITCAP', 228 'INITIAL', 229 'INSERT', 230 'INSERTCHILDXML', 231 'INSERTXMLBEFORE', 232 'INSTR', 233 'INSTRB', 234 'INTEGER', 235 'INTERFACE', 236 'INTERSECT', 237 'INTERVAL', 238 'INTO', 239 'IS', 240 'ISOLATION', 241 'ITERATION_NUMBER', 242 'JAVA', 243 'KEY', 244 'LAG', 245 'LAST', 246 'LAST_DAY', 247 'LAST_VALUE', 248 'LEAD', 249 'LEAST', 250 'LENGTH', 251 'LENGTHB', 252 'LEVEL', 253 'LIBRARY', 254 'LIKE', 255 'LIMITED', 256 'LINK', 257 'LN', 258 'LNNVL', 259 'LOCALTIMESTAMP', 260 'LOCK', 261 'LOG', 262 'LONG', 263 'LOOP', 264 'LOWER', 265 'LPAD', 266 'LTRIM', 267 'MAKE_REF', 268 'MATERIALIZED', 269 'MAX', 270 'MAXEXTENTS', 271 'MEDIAN', 272 'MIN', 273 'MINUS', 274 'MINUTE', 275 'MLSLABEL', 276 'MOD', 277 'MODE', 278 'MODIFY', 279 'MONTH', 280 'MONTHS_BETWEEN', 281 'NANVL', 282 'NATURAL', 283 'NATURALN', 284 'NCHR', 285 'NEW', 286 'NEW_TIME', 287 'NEXT_DAY', 288 'NEXTVAL', 289 'NLS_CHARSET_DECL_LEN', 290 'NLS_CHARSET_ID', 291 'NLS_CHARSET_NAME', 292 'NLS_INITCAP', 293 'NLS_LOWER', 294 'NLS_UPPER', 295 'NLSSORT', 296 'NOAUDIT', 297 'NOCOMPRESS', 298 'NOCOPY', 299 'NOT', 300 'NOWAIT', 301 'NTILE', 302 'NULL', 303 'NULLIF', 304 'NUMBER', 305 'NUMBER_BASE', 306 'NUMTODSINTERVAL', 307 'NUMTOYMINTERVAL', 308 'NVL', 309 'NVL2', 310 'OCIROWID', 311 'OF', 312 'OFFLINE', 313 'ON', 314 'ONLINE', 315 'OPAQUE', 316 'OPEN', 317 'OPERATOR', 318 'OPTION', 319 'OR', 320 'ORA_HASH', 321 'ORDER', 322 'ORGANIZATION', 323 'OTHERS', 324 'OUT', 325 'OUTLINE', 326 'PACKAGE', 327 'PARTITION', 328 'PATH', 329 'PCTFREE', 330 'PERCENT_RANK', 331 'PERCENTILE_CONT', 332 'PERCENTILE_DISC', 333 'PLAN', 334 'PLS_INTEGER', 335 'POSITIVE', 336 'POSITIVEN', 337 'POWER', 338 'POWERMULTISET', 339 'POWERMULTISET_BY_CARDINALITY', 340 'PRAGMA', 341 'PREDICTION', 342 'PREDICTION_BOUNDS', 343 'PREDICTION_COST', 344 'PREDICTION_DETAILS', 345 'PREDICTION_PROBABILITY', 346 'PREDICTION_SET', 347 'PRESENTNNV', 348 'PRESENTV', 349 'PREVIOUS', 350 'PRIMARY', 351 'PRIOR', 352 'PRIVATE', 353 'PRIVILEGES', 354 'PROCEDURE', 355 'PROFILE', 356 'PUBLIC', 357 'RAISE', 358 'RANGE', 359 'RANK', 360 'RATIO_TO_REPORT', 361 'RAW', 362 'RAWTOHEX', 363 'RAWTONHEX', 364 'REAL', 365 'RECORD', 366 'REF', 367 'REFTOHEX', 368 'REGEXP_COUNT', 369 'REGEXP_INSTR', 370 'REGEXP_REPLACE', 371 'REGEXP_SUBSTR', 372 'REGR_AVGX', 373 'REGR_AVGY', 374 'REGR_COUNT', 375 'REGR_INTERCEPT', 376 'REGR_R2', 377 'REGR_SLOPE', 378 'REGR_SXX', 379 'REGR_SXY', 380 'REGR_SYY', 381 'RELEASE', 382 'REMAINDER', 383 'RENAME', 384 'REPLACE', 385 'RESOURCE', 386 'RETURN', 387 'RETURNING', 388 'REVERSE', 389 'REVOKE', 390 'ROLE', 391 'ROLLBACK', 392 'ROUND', 393 'ROW', 394 'ROW_NUMBER', 395 'ROWID', 396 'ROWIDTOCHAR', 397 'ROWIDTONCHAR', 398 'ROWNUM', 399 'ROWS', 400 'ROWTYPE', 401 'RPAD', 402 'RTRIM', 403 'SAVEPOINT', 404 'SCHEMA', 405 'SCN_TO_TIMESTAMP', 406 'SECOND', 407 'SEGMENT', 408 'SELECT', 409 'SEPERATE', 410 'SEQUENCE', 411 'SESSION', 412 'SESSIONTIMEZONE', 413 'SET', 414 'SHARE', 415 'SIGN', 416 'SIN', 417 'SINH', 418 'SIZE', 419 'SMALLINT', 420 'SOUNDEX', 421 'SPACE', 422 'SQL', 423 'SQLCODE', 424 'SQLERRM', 425 'SQRT', 426 'START', 427 'STATISTICS', 428 'STATS_BINOMIAL_TEST', 429 'STATS_CROSSTAB', 430 'STATS_F_TEST', 431 'STATS_KS_TEST', 432 'STATS_MODE', 433 'STATS_MW_TEST', 434 'STATS_ONE_WAY_ANOVA', 435 'STATS_T_TEST_INDEP', 436 'STATS_T_TEST_INDEPU', 437 'STATS_T_TEST_ONE', 438 'STATS_T_TEST_PAIRED', 439 'STATS_WSR_TEST', 440 'STDDEV', 441 'STDDEV_POP', 442 'STDDEV_SAMP', 443 'STOP', 444 'SUBSTR', 445 'SUBSTRB', 446 'SUBTYPE', 447 'SUCCESSFUL', 448 'SUM', 449 'SYNONYM', 450 'SYS_CONNECT_BY_PATH', 451 'SYS_CONTEXT', 452 'SYS_DBURIGEN', 453 'SYS_EXTRACT_UTC', 454 'SYS_GUID', 455 'SYS_TYPEID', 456 'SYS_XMLAGG', 457 'SYS_XMLGEN', 458 'SYSDATE', 459 'SYSTEM', 460 'SYSTIMESTAMP', 461 'TABLE', 462 'TABLESPACE', 463 'TAN', 464 'TANH', 465 'TEMPORARY', 466 'THEN', 467 'TIME', 468 'TIMESTAMP', 469 'TIMESTAMP_TO_SCN', 470 'TIMEZONE_ABBR', 471 'TIMEZONE_HOUR', 472 'TIMEZONE_MINUTE', 473 'TIMEZONE_REGION', 474 'TIMING', 475 'TO', 476 'TO_BINARY_DOUBLE', 477 'TO_BINARY_FLOAT', 478 'TO_CHAR', 479 'TO_CLOB', 480 'TO_DATE', 481 'TO_DSINTERVAL', 482 'TO_LOB', 483 'TO_MULTI_BYTE', 484 'TO_NCHAR', 485 'TO_NCLOB', 486 'TO_NUMBER', 487 'TO_SINGLE_BYTE', 488 'TO_TIMESTAMP', 489 'TO_TIMESTAMP_TZ', 490 'TO_YMINTERVAL', 491 'TRANSACTION', 492 'TRANSLATE', 493 'TREAT', 494 'TRIGGER', 495 'TRIM', 496 'TRUE', 497 'TRUNC', 498 'TRUNCATE', 499 'TYPE', 500 'TZ_OFFSET', 501 'UI', 502 'UID', 503 'UNION', 504 'UNIQUE', 505 'UNISTR', 506 'UPDATE', 507 'UPDATEXML', 508 'UPPER', 509 'USE', 510 'USER', 511 'USERENV', 512 'USING', 513 'VALIDATE', 514 'VALUE', 515 'VALUES', 516 'VAR_POP', 517 'VAR_SAMP', 518 'VARCHAR', 519 'VARCHAR2', 520 'VARIANCE', 521 'VIEW', 522 'VSIZE', 523 'WHEN', 524 'WHENEVER', 525 'WHERE', 526 'WHILE', 527 'WIDTH_BUCKET', 528 'WITH', 529 'WORK', 530 'WRITE', 531 'XMLAGG', 532 'XMLCAST', 533 'XMLCDATA', 534 'XMLCOLATTVAL', 535 'XMLCOMMENT', 536 'XMLCONCAT', 537 'XMLDIFF', 538 'XMLELEMENT', 539 'XMLEXISTS', 540 'XMLFOREST', 541 'XMLPARSE', 542 'XMLPATCH', 543 'XMLPI', 544 'XMLQUERY', 545 'XMLROOT', 546 'XMLSEQUENCE', 547 'XMLSERIALIZE', 548 'XMLTABLE', 549 'XMLTRANSFORM', 550 'YEAR', 551 'ZONE' 552 ) 553 ), 554 'SYMBOLS' => array( 555 '(', ')', '=', '<', '>', '|', '+', '-', '*', '/', ',' 556 ), 557 'CASE_SENSITIVE' => array( 558 GESHI_COMMENTS => false, 559 1 => false, 560// 3 => false, 561// 4 => false, 562// 5 => false, 563// 6 => false 564 ), 565 'STYLES' => array( 566 'KEYWORDS' => array( 567 1 => 'color: #993333; font-weight: bold; text-transform: uppercase;' 568 ), 569 'COMMENTS' => array( 570 1 => 'color: #808080; font-style: italic;', 571 ), 572 'ESCAPE_CHAR' => array( 573 0 => 'color: #000099; font-weight: bold;' 574 ), 575 'BRACKETS' => array( 576 0 => 'color: #66cc66;' 577 ), 578 'STRINGS' => array( 579 0 => 'color: #ff0000;' 580 ), 581 'NUMBERS' => array( 582 0 => 'color: #cc66cc;' 583 ), 584 'METHODS' => array( 585 1 => 'color: #ff0000;' 586 ), 587 'SYMBOLS' => array( 588 0 => 'color: #66cc66;' 589 ), 590 'SCRIPT' => array( 591 ), 592 'REGEXPS' => array( 593 ) 594 ), 595 'URLS' => array( 596 1 => '', 597// 3 => '', 598// 4 => '', 599// 5 => '', 600// 6 => '' 601 ), 602 'OOLANG' => false, 603 'OBJECT_SPLITTERS' => array( 604 ), 605 'REGEXPS' => array( 606 ), 607 'STRICT_MODE_APPLIES' => GESHI_NEVER, 608 'SCRIPT_DELIMITERS' => array( 609 ), 610 'HIGHLIGHT_STRICT_BLOCK' => array( 611 ) 612); 613