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?
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
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