Tapatalk

Oracle Highlights

Oracle Highlights

1
NewbieNewbie
1

    Nov 15, 2005#1

    I am programming in Oracle packages and procedures, how do I get the highlight to work for this programming language. Has anyone defined the rules for this language?

    344
    MasterMaster
    344

      Nov 16, 2005#2

      Hi,

      yes, you can just download PL/SQL-wordfile from the UE web side and thats it.
      Or use mine (see below, eventually chance some minor things before).

      rds Bego

      Code: Select all

      /L7"PL/SQL" Nocase Line Comment = -- Block Comment On = /* Block Comment Off = */ File Extensions = SQL PKG PKB /Open Fold Strings = "{""FUNCTION" /Close Fold Strings = "}""END FUNCTION"
      /Delimiters = ~.!%@^&*()-+=|\/{}[]:;"'<> ,	?
      /Function String = "%[ ^t]++FUNCTION+[ ^t]+^([a-z0-9_]+^)[ {^p]++"
      /Function String 1 = "%[ ^t]++PROCEDURE+[ ^t]++^([a-z0-9_]+^)[ {^p]++"
      /C1"Keywords"
      ABORT ACCEPT ACCESS ADD ALL ALTER AND ANY ARRAY ARRAYLEN AS ASC ASSERT ASSIGN AT AUDIT AUTHORIZATION AVG
      BASE_TABLE BEGIN BETWEEN BINARY_INTEGER BODY BOOLEAN BY
      CASE CHAR CHAR_BASE CHECK CLOSE CLUSTER CLUSTERS COLAUTH COLUMN COMMENT COMMIT COMPRESS CONNECT CONSTANT CRASH CREATE CURRENT CURRVAL CURSOR CONSTRAINT
      DATABASE DATA_BASE DATE DBA DEBUGOFF DEBUGON DECLARE DECIMAL DEFAULT DEFINE DEFINITION DELAY  DESC DIGITS DISPOSE DISTINCT DO DROP DECODE
      else ELSIF END ENTRY EXCEPTION EXCEPTION_INIT EXCLUSIVE EXISTS EXIT
      FALSE FETCH FILE FLOAT FOR FORM FROM FUNCTION FOREIGN
      GENERIC GOTO GRANT GROUP GLOBAL
      HAVING
      IDENTIFIED IF IMMEDIATE IN INCREMENT INDEX INDEXES INDICATOR INITIAL INTEGER INTERFACE INTERSECT INTO IS
      KEY
      LEVEL LIKE LIMITED LOCK LONG LOOP LESS LTRIM
      MAX MAXEXTENTS MIN MINEXTENTS MINUS MISLABEL MOD MODE MINEXTENTS MAXEXTENTS MODIFY
      NATURAL NATURALN NEW NEXTVAL NOAUDIT NOCOMPRESS NOLOGGING NOT NOWAIT NULL NUMBER NUMBER_BASE next NVL 
      OF OFFLINE ON ONLINE OPEN OPTION OR ORDER OTHERS OUT
      package PARTITION PCTFREE PCTUSED PLS_INTEGER POSITIVE POSITIVEN PRAGMA PRIOR PRIVATE PRIVILEGES PROCEDURE PUBLIC PRIMARY PCTINCREASE PRESERVE
      RAISE RANGE RAW REAL ref RELEASE REMR RENAME RESOURCE RETURN REVERSE REVOKE ROLLBACK ROW ROWID ROWLABEL ROWNUM ROWS ROWTYPE RUN REFERENCING REFERENCES RTRIM ROUND
      SAVEPOINT SCHEMA SELECT SEPARATE SESSION SET SHARE SMALLINT SPACE SQL SQLCODE SQLERRM START STATEMENT STDDEV SUBTYPE SUCCESSFUL SUM SYNONYM SYSDATE STORAGE
      TABAUTH TABLE TABLES TABLESPACE TASK TERMINATE THEN TO TRIGGER TRUE TYPE TEMPORARY THAN
      UID UNION UNIQUE USE USER
      VALIDATE VALUES VARCHAR VARCHAR2 VARIANCE VIEW VIEWS
      WHEN WHENEVER WHERE WHILE WITH WORK WRITE
      xor
      /C2"Packages"
      BIND_VARIABLE BIND_VARIABLE_CHAR BIND_VARIABLE_RAW BIND_VARIABLE_ROWID BROKEN
      CHANGE CLOSE_CURSOR COLUMN_VALUE COLUMN_VALUE_CHAR COLUMN_VALUE_RAW COLUMN_VALUE_ROWID
      DEFINE_COLUMN DEFINE_COLUMN_CHAR DEFINE_COLUMN_RAW DEFINE_COLUMN_ROWID DISABLE
      ENABLE EXECUTE EXECUTE_AND_FETCH
      FETCH_ROWS
      GET_LINE GET_LINES
      INTERVAL IS_OPEN
      LAST_ERROR_POSITION LAST_ROW_COUNT LAST_ROW_ID LAST_SQL_FUNCTION_CODE
      NEW_LINE NEXT_DATE
      REMOVE
      SUBMIT
      TRACE(v_PROZ,'');
      WHAT
      ** DBMS_OUTPUT DBMS_JOB DBMS_SQL PA_DEBUG
      /C3"Constants"
      NO_DATA_FOUND
      /C4"SQL*Plus"
      ABS ADD_MONTHS ASCII
      CEIL CHR CONCAT CONVERT COS COSH
      exec EXECUTE exp
      FLOOR
      GRANT GREATEST
      HEXTORAW
      INITCAP INSTR
      LAST_DAY LENGTH LN LOG LOWER LPAD 
      MOD MONTHS_BETWEEN
      POWER PROMPT
      RAWTOHEX REPLACE ROWIDTOCHAR RPAD REPLACE RUN
      START SIGN SIN SINH SOUNDEX SQRT SUBSTR SUBSTRB
      TAN TANH TO_CHAR TO_DATE TO_LABEL TO_MULTI_BYTE TO_NUMBER TO_SINGLE_TYPE TRANSLATE TRUNC
      UPPER USERENV
      VSIZE
      /C5"Proj.specific"
      ** batch_ bde_ open_file read_file close_file print_fehler_rec e_Global
      /C6"RECORDS"
      ** REC_
      RECORD
      /C7"Variables"
      ** v_ error_
      /C8"DML-STATEMENTS"
      delete 
      INSERT
      SET 
      UPDATE
      values
      Normally using all newest english version incl. each hotfix. Win 10 64 bit