basis/xmode/modes/pl-sql.xml

   1 <?xml version="1.0"?>
   2
   3 <!DOCTYPE MODE SYSTEM "xmode.dtd">
   4
   5 <MODE>
   6         <PROPS>
   7                 <PROPERTY NAME="commentStart" VALUE="/*" />
   8                 <PROPERTY NAME="commentEnd" VALUE="*/" />
   9                 <PROPERTY NAME="lineComment" VALUE="--" />
  10         <PROPERTY NAME="indentNextLines" VALUE="\s*(.*THEN|ELSE|LOOP).*" />
  11                 <PROPERTY NAME="unindentNextLines" VALUE="^\s*(ELSE|ELSIF|END IF|END LOOP).*" />
  12                 <PROPERTY NAME="unindentThisLine" VALUE="^\s*(ELSE|ELSIF|END IF|END LOOP).*" />
  13         </PROPS>
  14         <RULES IGNORE_CASE="TRUE" HIGHLIGHT_DIGITS="TRUE">
  15                 <SPAN TYPE="LABEL">
  16                         <BEGIN>/*+</BEGIN>
  17                         <END>*/</END>
  18                 </SPAN>
  19                 <SPAN TYPE="COMMENT1">
  20                         <BEGIN>/*</BEGIN>
  21                         <END>*/</END>
  22                 </SPAN>
  23                 <SPAN TYPE="LITERAL1">
  24                         <BEGIN>'</BEGIN>
  25                         <END>'</END>
  26                 </SPAN>
  27                 <SPAN TYPE="LITERAL1">
  28                         <BEGIN>"</BEGIN>
  29                         <END>"</END>
  30                 </SPAN>
  31                 <SPAN TYPE="LITERAL1" NO_LINE_BREAK="TRUE">
  32                         <BEGIN>[</BEGIN>
  33                         <END>]</END>
  34                 </SPAN>
  35                 <EOL_SPAN TYPE="LABEL">--+</EOL_SPAN>
  36                 <EOL_SPAN TYPE="COMMENT1">--</EOL_SPAN>
  37                 <EOL_SPAN TYPE="COMMENT1" AT_LINE_START="TRUE">REM </EOL_SPAN>
  38         <EOL_SPAN TYPE="COMMENT1" AT_LINE_START="TRUE">REMARK</EOL_SPAN>
  39                 <SEQ TYPE="OPERATOR">+</SEQ>
  40                 <SEQ TYPE="OPERATOR">-</SEQ>
  41                 <SEQ TYPE="OPERATOR">/</SEQ>
  42                 <SEQ TYPE="OPERATOR">*</SEQ>
  43                 <SEQ TYPE="OPERATOR">=</SEQ>
  44                 <SEQ TYPE="OPERATOR">&gt;</SEQ>
  45                 <SEQ TYPE="OPERATOR">&lt;</SEQ>
  46                 <SEQ TYPE="OPERATOR">%</SEQ>
  47                 <SEQ TYPE="OPERATOR">&amp;</SEQ>
  48                 <SEQ TYPE="OPERATOR">|</SEQ>
  49                 <SEQ TYPE="OPERATOR">^</SEQ>
  50                 <SEQ TYPE="OPERATOR">~</SEQ>
  51                 <SEQ TYPE="OPERATOR">!=</SEQ>
  52                 <SEQ TYPE="OPERATOR">!&gt;</SEQ>
  53                 <SEQ TYPE="OPERATOR">!&lt;</SEQ>
  54                 <SEQ TYPE="OPERATOR">:=</SEQ>
  55                 <SEQ TYPE="OPERATOR">.</SEQ>
  56                 <SEQ TYPE="OPERATOR">(</SEQ>
  57                 <SEQ TYPE="OPERATOR">)</SEQ>
  58         <MARK_FOLLOWING AT_LINE_START="TRUE" AT_WHITESPACE_END="TRUE"
  59                 TYPE="LABEL">@@</MARK_FOLLOWING>
  60         <MARK_FOLLOWING AT_LINE_START="TRUE"
  61                 AT_WHITESPACE_END="TRUE" TYPE="LABEL">@</MARK_FOLLOWING>
  62                 <EOL_SPAN AT_LINE_START="TRUE" DELEGATE="shellscript::MAIN">!</EOL_SPAN>
  63                 <EOL_SPAN AT_LINE_START="TRUE"
  64                 DELEGATE="shellscript::MAIN">host</EOL_SPAN>
  65                 <MARK_PREVIOUS TYPE="LABEL" AT_LINE_START="TRUE">:</MARK_PREVIOUS>
  66
  67                 <KEYWORDS>
  68                         <!-- reserved words -->
  69                         <KEYWORD1>ABORT</KEYWORD1>
  70                         <KEYWORD1>ACCESS</KEYWORD1>
  71                         <KEYWORD1>ACCEPT</KEYWORD1>
  72                         <KEYWORD1>ADD</KEYWORD1>
  73                         <KEYWORD1>ALTER</KEYWORD1>
  74                         <KEYWORD1>ARRAY</KEYWORD1>
  75                         <KEYWORD1>ARRAY_LEN</KEYWORD1>
  76                         <KEYWORD1>AS</KEYWORD1>
  77                         <KEYWORD1>ASC</KEYWORD1>
  78                         <KEYWORD1>ASSERT</KEYWORD1>
  79                         <KEYWORD1>ASSIGN</KEYWORD1>
  80                         <KEYWORD1>AT</KEYWORD1>
  81                         <KEYWORD1>AUDIT</KEYWORD1>
  82                         <KEYWORD1>AUTHORIZATION</KEYWORD1>
  83                         <KEYWORD1>AVG</KEYWORD1>
  84                         <KEYWORD1>BASE_TABLE</KEYWORD1>
  85                         <KEYWORD1>BEGIN</KEYWORD1>
  86                         <KEYWORD1>BINARY_INTEGER</KEYWORD1>
  87                         <KEYWORD1>BODY</KEYWORD1>
  88                         <KEYWORD1>BREAK</KEYWORD1>
  89                         <KEYWORD1>BREAKS</KEYWORD1>
  90                         <KEYWORD1>BTITLE</KEYWORD1>
  91                         <KEYWORD1>CASE</KEYWORD1>
  92                         <KEYWORD1>CALL</KEYWORD1>
  93                         <KEYWORD1>CENTER</KEYWORD1>
  94                         <KEYWORD1>CHAR</KEYWORD1>
  95                         <KEYWORD1>CHAR_BASE</KEYWORD1>
  96                         <KEYWORD1>CHECK</KEYWORD1>
  97                         <KEYWORD1>CLEAR</KEYWORD1>
  98                         <KEYWORD1>CLOSE</KEYWORD1>
  99                         <KEYWORD1>CLUSTER</KEYWORD1>
 100                         <KEYWORD1>CLUSTERS</KEYWORD1>
 101                         <KEYWORD1>CMPVAR</KEYWORD1>
 102                         <KEYWORD1>COL</KEYWORD1>
 103                         <KEYWORD1>COLAUTH</KEYWORD1>
 104                         <KEYWORD1>COLUMN</KEYWORD1>
 105                         <KEYWORD1>COLUMNS</KEYWORD1>
 106                         <KEYWORD1>COMMENT</KEYWORD1>
 107                         <KEYWORD1>COMMIT</KEYWORD1>
 108                         <KEYWORD1>COMPRESS</KEYWORD1>
 109                         <KEYWORD1>COMPUTE</KEYWORD1>
 110                         <KEYWORD1>CONSTANT</KEYWORD1>
 111                         <KEYWORD1>CONSTRAINT</KEYWORD1>
 112                         <KEYWORD1>CONTINUE</KEYWORD1>
 113                         <KEYWORD1>COUNT</KEYWORD1>
 114                         <KEYWORD1>CREATE</KEYWORD1>
 115                         <KEYWORD1>CURRENT</KEYWORD1>
 116                         <KEYWORD1>CURRVAL</KEYWORD1>
 117                         <KEYWORD1>CURSOR</KEYWORD1>
 118                         <KEYWORD1>DATABASE</KEYWORD1>
 119                         <KEYWORD1>DATA_BASE</KEYWORD1>
 120                         <KEYWORD1>DATE</KEYWORD1>
 121                         <KEYWORD1>DBA</KEYWORD1>
 122                         <KEYWORD1>DEBUGOFF</KEYWORD1>
 123                         <KEYWORD1>DEBUGON</KEYWORD1>
 124                         <KEYWORD1>DECLARE</KEYWORD1>
 125                         <KEYWORD1>DEFAULT</KEYWORD1>
 126                         <KEYWORD1>DEFINITION</KEYWORD1>
 127                         <KEYWORD1>DELAY</KEYWORD1>
 128                         <KEYWORD1>DELETE</KEYWORD1>
 129                         <KEYWORD1>DESC</KEYWORD1>
 130                         <KEYWORD1>EXPLAIN</KEYWORD1>
 131                         <KEYWORD1>DIGITS</KEYWORD1>
 132                         <KEYWORD1>DISPOSE</KEYWORD1>
 133                         <KEYWORD1>DISTINCT</KEYWORD1>
 134                         <KEYWORD1>DO</KEYWORD1>
 135                         <KEYWORD1>DROP</KEYWORD1>
 136                         <KEYWORD1>DUMP</KEYWORD1>
 137                         <KEYWORD1>ELSE</KEYWORD1>
 138                         <KEYWORD1>ELSIF</KEYWORD1>
 139                         <KEYWORD1>END</KEYWORD1>
 140                         <KEYWORD1>ENTRY</KEYWORD1>>
 141                         <KEYWORD1>ERRORS</KEYWORD1>
 142                         <KEYWORD1>EXCEPTION</KEYWORD1>
 143                         <KEYWORD1>EXCEPTION_INIT</KEYWORD1>
 144                         <KEYWORD1>EXCLUSIVE</KEYWORD1>
 145                         <KEYWORD1>EXECUTE</KEYWORD1>
 146                         <KEYWORD1>EXIT</KEYWORD1>
 147                         <KEYWORD1>EXTERNAL</KEYWORD1>
 148                         <KEYWORD1>FALSE</KEYWORD1>
 149                         <KEYWORD1>FETCH</KEYWORD1>
 150                         <KEYWORD1>FILE</KEYWORD1>
 151                         <KEYWORD1>FOR</KEYWORD1>
 152             <KEYWORD1>FOREIGN</KEYWORD1>
 153                         <KEYWORD1>FORM</KEYWORD1>
 154                         <KEYWORD1>FORMAT</KEYWORD1>
 155                         <KEYWORD1>FROM</KEYWORD1>
 156                         <KEYWORD1>FUNCTION</KEYWORD1>
 157                         <KEYWORD1>GENERIC</KEYWORD1>
 158                         <KEYWORD1>GOTO</KEYWORD1>
 159                         <KEYWORD1>GRANT</KEYWORD1>
 160                         <KEYWORD1>GREATEST</KEYWORD1>
 161                         <KEYWORD1>GROUP</KEYWORD1>
 162                         <KEYWORD1>HAVING</KEYWORD1>
 163                         <KEYWORD1>HEADING</KEYWORD1>
 164                         <KEYWORD1>IDENTIFIED</KEYWORD1>
 165                         <KEYWORD1>IDENTITYCOL</KEYWORD1>
 166                         <KEYWORD1>IF</KEYWORD1>
 167                         <KEYWORD1>IMMEDIATE</KEYWORD1>
 168                         <KEYWORD1>INCREMENT</KEYWORD1>
 169                         <KEYWORD1>INDEX</KEYWORD1>
 170                         <KEYWORD1>INDEXES</KEYWORD1>
 171                         <KEYWORD1>INDICATOR</KEYWORD1>
 172                         <KEYWORD1>INITIAL</KEYWORD1>
 173                         <KEYWORD1>INSERT</KEYWORD1>
 174                         <KEYWORD1>INTERFACE</KEYWORD1>
 175                         <KEYWORD1>INTO</KEYWORD1>
 176                         <KEYWORD1>IS</KEYWORD1>
 177                         <KEYWORD1>KEY</KEYWORD1>
 178                         <KEYWORD1>LEAST</KEYWORD1>
 179                         <KEYWORD1>LEVEL</KEYWORD1>
 180                         <KEYWORD1>LIMITED</KEYWORD1>
 181                         <KEYWORD1>LOCK</KEYWORD1>
 182                         <KEYWORD1>LONG</KEYWORD1>
 183                         <KEYWORD1>LOOP</KEYWORD1>
 184                         <KEYWORD1>MATCHED</KEYWORD1>
 185                         <KEYWORD1>MAX</KEYWORD1>
 186                         <KEYWORD1>MAXEXTENTS</KEYWORD1>
 187                         <KEYWORD1>MERGE</KEYWORD1>
 188                         <KEYWORD1>MEMBER</KEYWORD1>
 189                         <KEYWORD1>MIN</KEYWORD1>
 190                         <KEYWORD1>MINUS</KEYWORD1>
 191                         <KEYWORD1>MLSLABEL</KEYWORD1>
 192                         <KEYWORD1>MOD</KEYWORD1>
 193                         <KEYWORD1>MODIFY</KEYWORD1>
 194                         <KEYWORD1>MORE</KEYWORD1>
 195                         <KEYWORD1>NATURAL</KEYWORD1>
 196                         <KEYWORD1>NATURALN</KEYWORD1>
 197                         <KEYWORD1>NEW</KEYWORD1>
 198                         <KEYWORD1>NEW_VALUE</KEYWORD1>
 199                         <KEYWORD1>NEXT</KEYWORD1>
 200                         <KEYWORD1>NEXTVAL</KEYWORD1>
 201                         <KEYWORD1>NOAUDIT</KEYWORD1>
 202                         <KEYWORD1>NOCOMPRESS</KEYWORD1>
 203                         <KEYWORD1>NOPRINT</KEYWORD1>
 204                         <KEYWORD1>NOWAIT</KEYWORD1>
 205                         <KEYWORD1>NULL</KEYWORD1>
 206                         <KEYWORD1>NUMBER</KEYWORD1>
 207                         <KEYWORD1>NUMBER_BASE</KEYWORD1>
 208                         <KEYWORD1>OF</KEYWORD1>
 209                         <KEYWORD1>OFFLINE</KEYWORD1>
 210                         <KEYWORD1>ON</KEYWORD1>
 211                         <KEYWORD1>OFF</KEYWORD1>
 212                         <KEYWORD1>ONLINE</KEYWORD1>
 213                         <KEYWORD1>OPEN</KEYWORD1>
 214                         <KEYWORD1>OPTION</KEYWORD1>
 215                         <KEYWORD1>ORDER</KEYWORD1>
 216                         <KEYWORD1>ORGANIZATION</KEYWORD1>
 217                         <KEYWORD1>OTHERS</KEYWORD1>
 218                         <KEYWORD1>OUT</KEYWORD1>
 219                         <KEYWORD1>PACKAGE</KEYWORD1>
 220                         <KEYWORD1>PAGE</KEYWORD1>
 221                         <KEYWORD1>PARTITION</KEYWORD1>
 222                         <KEYWORD1>PCTFREE</KEYWORD1>
 223                         <KEYWORD1>PCTINCREASE</KEYWORD1>
 224                         <KEYWORD1>PLAN</KEYWORD1>
 225                         <KEYWORD1>POSITIVE</KEYWORD1>
 226                         <KEYWORD1>POSITIVEN</KEYWORD1>
 227                         <KEYWORD1>PRAGMA</KEYWORD1>
 228                         <KEYWORD1>PRINT</KEYWORD1>
 229                         <KEYWORD1>PRIMARY</KEYWORD1>
 230                         <KEYWORD1>PRIOR</KEYWORD1>
 231                         <KEYWORD1>PRIVATE</KEYWORD1>
 232                         <KEYWORD1>PRIVILEGES</KEYWORD1>
 233                         <KEYWORD1>PROCEDURE</KEYWORD1>
 234                         <KEYWORD1>PROMPT</KEYWORD1>
 235                         <KEYWORD1>PUBLIC</KEYWORD1>
 236                         <KEYWORD1>QUOTED_IDENTIFIER</KEYWORD1>
 237                         <KEYWORD1>RAISE</KEYWORD1>
 238                         <KEYWORD1>RANGE</KEYWORD1>
 239                         <KEYWORD1>RAW</KEYWORD1>
 240                         <KEYWORD1>RECORD</KEYWORD1>
 241                         <KEYWORD1>REF</KEYWORD1>
 242             <KEYWORD1>REFERENCES</KEYWORD1>
 243                         <KEYWORD1>RELEASE</KEYWORD1>
 244                         <KEYWORD1>REMR</KEYWORD1>
 245                         <KEYWORD1>RENAME</KEYWORD1>
 246                         <KEYWORD1>RESOURCE</KEYWORD1>
 247                         <KEYWORD1>RETURN</KEYWORD1>
 248                         <KEYWORD1>REVERSE</KEYWORD1>
 249                         <KEYWORD1>REVOKE</KEYWORD1>
 250                         <KEYWORD1>ROLLBACK</KEYWORD1>
 251                         <KEYWORD1>ROW</KEYWORD1>
 252                         <KEYWORD1>ROWID</KEYWORD1>
 253                         <KEYWORD1>ROWLABEL</KEYWORD1>
 254                         <KEYWORD1>ROWNUM</KEYWORD1>
 255                         <KEYWORD1>ROWS</KEYWORD1>
 256                         <KEYWORD1>ROWTYPE</KEYWORD1>
 257                         <KEYWORD1>RUN</KEYWORD1>
 258                         <KEYWORD1>SAVEPOINT</KEYWORD1>
 259                         <KEYWORD1>SCHEMA</KEYWORD1>
 260                         <KEYWORD1>SELECT</KEYWORD1>
 261                         <KEYWORD1>SEPERATE</KEYWORD1>
 262                         <KEYWORD1>SEQUENCE</KEYWORD1>
 263                         <KEYWORD1>SESSION</KEYWORD1>
 264                         <KEYWORD1>SET</KEYWORD1>
 265                         <KEYWORD1>SHARE</KEYWORD1>
 266                         <KEYWORD1>SHOW</KEYWORD1>
 267                         <KEYWORD1>SIGNTYPE</KEYWORD1>
 268                         <KEYWORD1>SKIP</KEYWORD1>
 269                         <KEYWORD1>SPACE</KEYWORD1>
 270                         <KEYWORD1>SPOOL</KEYWORD1>
 271                         <NULL>.SQL</NULL> <!-- for 'SPOOL some.sql;' stuff -->
 272                         <KEYWORD1>SQL</KEYWORD1>
 273                         <KEYWORD1>SQLCODE</KEYWORD1>
 274                         <KEYWORD1>SQLERRM</KEYWORD1>
 275                         <KEYWORD1>SQLERROR</KEYWORD1>
 276                         <KEYWORD1>STATEMENT</KEYWORD1>
 277                         <KEYWORD1>STDDEV</KEYWORD1>
 278                         <KEYWORD1>STORAGE</KEYWORD1>
 279                         <KEYWORD1>SUBTYPE</KEYWORD1>
 280                         <KEYWORD1>SUCCESSFULL</KEYWORD1>
 281                         <KEYWORD1>SUM</KEYWORD1>
 282                         <KEYWORD1>SYNONYM</KEYWORD1>
 283                         <KEYWORD1>SYSDATE</KEYWORD1>
 284                         <KEYWORD1>TABAUTH</KEYWORD1>
 285                         <KEYWORD1>TABLE</KEYWORD1>
 286                         <KEYWORD1>TABLES</KEYWORD1>
 287                         <KEYWORD1>TABLESPACE</KEYWORD1>
 288                         <KEYWORD1>TASK</KEYWORD1>
 289                         <KEYWORD1>TERMINATE</KEYWORD1>
 290                         <KEYWORD1>THEN</KEYWORD1>
 291                         <KEYWORD1>TO</KEYWORD1>
 292                         <KEYWORD1>TRIGGER</KEYWORD1>
 293                         <KEYWORD1>TRUE</KEYWORD1>
 294                         <KEYWORD1>TRUNCATE</KEYWORD1>
 295                         <KEYWORD1>TTITLE</KEYWORD1>
 296                         <KEYWORD1>TYPE</KEYWORD1>
 297                         <KEYWORD1>UID</KEYWORD1>
 298                         <KEYWORD1>UNION</KEYWORD1>
 299                         <KEYWORD1>UNIQUE</KEYWORD1>
 300                         <KEYWORD1>UNDEFINE</KEYWORD1>
 301                         <KEYWORD1>UPDATE</KEYWORD1>
 302                         <KEYWORD1>UPDATETEXT</KEYWORD1>
 303                         <KEYWORD1>USE</KEYWORD1>
 304                         <KEYWORD1>USER</KEYWORD1>
 305                         <KEYWORD1>USING</KEYWORD1>
 306                         <KEYWORD1>VALIDATE</KEYWORD1>
 307                         <KEYWORD1>VALUES</KEYWORD1>
 308                         <KEYWORD1>VARIANCE</KEYWORD1>
 309                         <KEYWORD1>VIEW</KEYWORD1>
 310                         <KEYWORD1>VIEWS</KEYWORD1>
 311                         <KEYWORD1>WHEN</KEYWORD1>
 312                         <KEYWORD1>WHENEVER</KEYWORD1>
 313                         <KEYWORD1>WHERE</KEYWORD1>
 314                         <KEYWORD1>WHILE</KEYWORD1>
 315                         <KEYWORD1>WITH</KEYWORD1>
 316                         <KEYWORD1>WORK</KEYWORD1>
 317                         <KEYWORD1>WRITE</KEYWORD1>
 318                         <KEYWORD1>XOR</KEYWORD1>
 319
 320                         <!-- data types -->
 321                         <KEYWORD1>binary</KEYWORD1>
 322                         <KEYWORD1>bit</KEYWORD1>
 323                         <KEYWORD1>blob</KEYWORD1>
 324                         <KEYWORD1>boolean</KEYWORD1>
 325                         <KEYWORD1>char</KEYWORD1>
 326                         <KEYWORD1>character</KEYWORD1>
 327                         <KEYWORD1>datetime</KEYWORD1>
 328                         <KEYWORD1>decimal</KEYWORD1>
 329                         <KEYWORD1>float</KEYWORD1>
 330                         <KEYWORD1>image</KEYWORD1>
 331                         <KEYWORD1>int</KEYWORD1>
 332                         <KEYWORD1>integer</KEYWORD1>
 333                         <KEYWORD1>money</KEYWORD1>
 334                         <KEYWORD1>numeric</KEYWORD1>
 335                         <KEYWORD1>nchar</KEYWORD1>
 336                         <KEYWORD1>nvarchar</KEYWORD1>
 337                         <KEYWORD1>ntext</KEYWORD1>
 338                         <KEYWORD1>object</KEYWORD1>
 339                         <KEYWORD1>pls_integer</KEYWORD1>
 340                         <KEYWORD1>real</KEYWORD1>
 341                         <KEYWORD1>smalldatetime</KEYWORD1>
 342                         <KEYWORD1>smallint</KEYWORD1>
 343                         <KEYWORD1>smallmoney</KEYWORD1>
 344                         <KEYWORD1>text</KEYWORD1>
 345                         <KEYWORD1>timestamp</KEYWORD1>
 346                         <KEYWORD1>tinyint</KEYWORD1>
 347                         <KEYWORD1>uniqueidentifier</KEYWORD1>
 348                         <KEYWORD1>varbinary</KEYWORD1>
 349                         <KEYWORD1>varchar</KEYWORD1>
 350                         <KEYWORD1>varchar2</KEYWORD1>
 351                         <KEYWORD1>varray</KEYWORD1>
 352
 353                         <!-- system functions -->
 354                         <KEYWORD2>ABS</KEYWORD2>
 355                         <KEYWORD2>ACOS</KEYWORD2>
 356                         <KEYWORD2>ADD_MONTHS</KEYWORD2>
 357                         <KEYWORD2>ASCII</KEYWORD2>
 358                         <KEYWORD2>ASIN</KEYWORD2>
 359                         <KEYWORD2>ATAN</KEYWORD2>
 360                         <KEYWORD2>ATAN2</KEYWORD2>
 361                         <KEYWORD2>BITAND</KEYWORD2>
 362                         <KEYWORD2>CEIL</KEYWORD2>
 363                         <KEYWORD2>CHARTOROWID</KEYWORD2>
 364                         <KEYWORD2>CHR</KEYWORD2>
 365                         <KEYWORD2>CONCAT</KEYWORD2>
 366                         <KEYWORD2>CONVERT</KEYWORD2>
 367                         <KEYWORD2>COS</KEYWORD2>
 368                         <KEYWORD2>COSH</KEYWORD2>
 369                         <KEYWORD2>DECODE</KEYWORD2>
 370                         <KEYWORD2>DEFINE</KEYWORD2>
 371                         <KEYWORD2>DUAL</KEYWORD2>
 372                         <KEYWORD2>FLOOR</KEYWORD2>
 373                         <KEYWORD2>HEXTORAW</KEYWORD2>
 374                         <KEYWORD2>INITCAP</KEYWORD2>
 375                         <KEYWORD2>INSTR</KEYWORD2>
 376                         <KEYWORD2>INSTRB</KEYWORD2>
 377                         <KEYWORD2>LAST_DAY</KEYWORD2>
 378                         <KEYWORD2>LENGTH</KEYWORD2>
 379                         <KEYWORD2>LENGTHB</KEYWORD2>
 380                         <KEYWORD2>LN</KEYWORD2>
 381                         <KEYWORD2>LOG</KEYWORD2>
 382                         <KEYWORD2>LOWER</KEYWORD2>
 383                         <KEYWORD2>LPAD</KEYWORD2>
 384                         <KEYWORD2>LTRIM</KEYWORD2>
 385                         <KEYWORD2>MOD</KEYWORD2>
 386                         <KEYWORD2>MONTHS_BETWEEN</KEYWORD2>
 387                         <KEYWORD2>NEW_TIME</KEYWORD2>
 388                         <KEYWORD2>NEXT_DAY</KEYWORD2>
 389                         <KEYWORD2>NLSSORT</KEYWORD2>
 390                         <KEYWORD2>NSL_INITCAP</KEYWORD2>
 391                         <KEYWORD2>NLS_LOWER</KEYWORD2>
 392                         <KEYWORD2>NLS_UPPER</KEYWORD2>
 393                         <KEYWORD2>NVL</KEYWORD2>
 394                         <KEYWORD2>POWER</KEYWORD2>
 395                         <KEYWORD2>RAWTOHEX</KEYWORD2>
 396                         <KEYWORD2>REPLACE</KEYWORD2>
 397                         <KEYWORD2>ROUND</KEYWORD2>
 398                         <KEYWORD2>ROWIDTOCHAR</KEYWORD2>
 399                         <KEYWORD2>RPAD</KEYWORD2>
 400                         <KEYWORD2>RTRIM</KEYWORD2>
 401                         <KEYWORD2>SIGN</KEYWORD2>
 402                         <KEYWORD2>SOUNDEX</KEYWORD2>
 403                         <KEYWORD2>SIN</KEYWORD2>
 404                         <KEYWORD2>SINH</KEYWORD2>
 405                         <KEYWORD2>SQRT</KEYWORD2>
 406                         <KEYWORD2>SUBSTR</KEYWORD2>
 407                         <KEYWORD2>SUBSTRB</KEYWORD2>
 408                         <KEYWORD2>TAN</KEYWORD2>
 409                         <KEYWORD2>TANH</KEYWORD2>
 410                         <KEYWORD2>TO_CHAR</KEYWORD2>
 411                         <KEYWORD2>TO_DATE</KEYWORD2>
 412                         <KEYWORD2>TO_MULTIBYTE</KEYWORD2>
 413                         <KEYWORD2>TO_NUMBER</KEYWORD2>
 414                         <KEYWORD2>TO_SINGLE_BYTE</KEYWORD2>
 415                         <KEYWORD2>TRANSLATE</KEYWORD2>
 416                         <KEYWORD2>TRUNC</KEYWORD2>
 417                         <KEYWORD2>UPPER</KEYWORD2>
 418
 419                         <!-- operators -->
 420                         <KEYWORD1>ALL</KEYWORD1>
 421                         <KEYWORD1>AND</KEYWORD1>
 422                         <KEYWORD1>ANY</KEYWORD1>
 423                         <KEYWORD1>BETWEEN</KEYWORD1>
 424                         <KEYWORD1>BY</KEYWORD1>
 425                         <KEYWORD1>CONNECT</KEYWORD1>
 426                         <KEYWORD1>EXISTS</KEYWORD1>
 427                         <KEYWORD1>IN</KEYWORD1>
 428                         <KEYWORD1>INTERSECT</KEYWORD1>
 429                         <KEYWORD1>LIKE</KEYWORD1>
 430                         <KEYWORD1>NOT</KEYWORD1>
 431                         <KEYWORD1>NULL</KEYWORD1>
 432                         <KEYWORD1>OR</KEYWORD1>
 433                         <KEYWORD1>START</KEYWORD1>
 434                         <KEYWORD1>UNION</KEYWORD1>
 435                         <KEYWORD1>WITH</KEYWORD1>
 436                         <KEYWORD1>NOTFOUND</KEYWORD1>
 437                         <KEYWORD1>ISOPEN</KEYWORD1>
 438                         <KEYWORD1>JOIN</KEYWORD1>
 439                         <KEYWORD1>LEFT</KEYWORD1>
 440                         <KEYWORD1>RIGHT</KEYWORD1>
 441                         <KEYWORD1>FULL</KEYWORD1>
 442                         <KEYWORD1>OUTER</KEYWORD1>
 443                         <KEYWORD1>CROSS</KEYWORD1>
 444
 445                         <!-- Some common packages -->
 446                         <KEYWORD3>DBMS_SQL</KEYWORD3>
 447                         <FUNCTION>OPEN_CURSOR</FUNCTION>
 448                         <FUNCTION>PARSE</FUNCTION>
 449                         <FUNCTION>BIND_VARIABLE</FUNCTION>
 450                         <FUNCTION>BIND_ARRAY</FUNCTION>
 451                         <FUNCTION>DEFINE_COLUMN</FUNCTION>
 452                         <FUNCTION>DEFINE_COLUMN_LONG</FUNCTION>
 453                         <FUNCTION>DEFINE_ARRAY</FUNCTION>
 454                         <FUNCTION>EXECUTE</FUNCTION>
 455                         <FUNCTION>FETCH_ROWS</FUNCTION>
 456                         <FUNCTION>EXECUTE_AND_FETCH</FUNCTION>
 457                         <FUNCTION>VARIABLE_VALUE</FUNCTION>
 458                         <FUNCTION>COLUMN_VALUE</FUNCTION>
 459                         <FUNCTION>COLUMN_VALUE_LONG</FUNCTION>
 460                         <FUNCTION>CLOSE_CURSOR</FUNCTION>
 461                         <FUNCTION>DEFINE_COLUMN_CHAR</FUNCTION>
 462                         <FUNCTION>COLUMN_VALUE_CHAR</FUNCTION>
 463
 464                         <KEYWORD3>DBMS_PROFILER</KEYWORD3>
 465                         <FUNCTION>START_PROFILER</FUNCTION>
 466                         <FUNCTION>STOP_PROFILER</FUNCTION>
 467                         <FUNCTION>ROLLUP_RUN</FUNCTION>
 468
 469                         <!-- other keywords (output-related) -->
 470                         <KEYWORD3>_EDITOR</KEYWORD3>
 471                         <KEYWORD3>ARRAYSIZE</KEYWORD3>
 472                         <KEYWORD3>AUTOTRACE</KEYWORD3>
 473                         <KEYWORD3>DBMS_OUTPUT</KEYWORD3>
 474                         <KEYWORD3>ECHO</KEYWORD3>
 475                         <KEYWORD3>ENABLE</KEYWORD3>
 476                         <KEYWORD3>FCLOSE</KEYWORD3>
 477                         <KEYWORD3>FCLOSE_ALL</KEYWORD3>
 478                         <KEYWORD3>FEED</KEYWORD3>
 479                         <KEYWORD3>FEEDBACK</KEYWORD3>
 480                         <KEYWORD3>FILE_TYPE</KEYWORD3>
 481                         <KEYWORD3>FOPEN</KEYWORD3>
 482                         <KEYWORD3>HEAD</KEYWORD3>
 483                         <KEYWORD3>INVALID_OPERATION</KEYWORD3>
 484                         <KEYWORD3>INVALID_PATH</KEYWORD3>
 485                         <KEYWORD3>LINESIZE</KEYWORD3>
 486                         <KEYWORD3>PAGESIZE</KEYWORD3>
 487                         <KEYWORD3>PAGES</KEYWORD3>
 488                         <KEYWORD3>PAUSE</KEYWORD3>
 489                         <KEYWORD3>DOC</KEYWORD3>
 490                         <KEYWORD3>PUTF</KEYWORD3>
 491                         <KEYWORD3>PUT_LINE</KEYWORD3>
 492                         <KEYWORD3>SERVEROUTPUT</KEYWORD3>
 493                         <KEYWORD3>SQL.PNO</KEYWORD3>
 494                         <KEYWORD3>UTL_FILE</KEYWORD3>
 495                         <KEYWORD3>VER</KEYWORD3>
 496                         <KEYWORD3>VERIFY</KEYWORD3>
 497                         <KEYWORD3>WRITE_ERROR</KEYWORD3>
 498                 </KEYWORDS>
 499         </RULES>
 500 </MODE>
 501
 502