在UE中設(shè)置PLSQL的加亮模式
?
??? UE默認(rèn)的安裝中是沒(méi)有PLSQL的顯示模式的(至少我安裝的版本沒(méi)有)，所以需要自己手動(dòng)進(jìn)行設(shè)置，設(shè)置方法如下：
?
??? 首先，打開(kāi)UE的格式配置文檔?? C:\Program Files\IDM COMPUTER SOLUTIONS\ULTRAEDIT-32\wordfile.txt
??? 這個(gè)文件是安裝之后默認(rèn)配置文件，當(dāng)然也可以自己指定位置。
?
??? 然后在wordfile.txt文件最后加入以下代碼：
/L12"PL/SQL" Nocase Line Comment = -- Block Comment On = /* Block Comment Off = */ File Extensions = SQL
/Delimiters =
~!%@^&*()-+=|\/{}[]:;"'
<> ,? .?
/Function String = "%[A-Z _]*[~\s]+(*)"
/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
??? DATABASE DATA_BASE DATE DBA DEBUGOFF DEBUGON DECLARE DECIMAL DEFAULT DEFINITION DELAY DELETE DESC DIGITS DISPOSE DISTINCT DO DROP
??? ELSE ELSIF END ENTRY EXCEPTION EXCEPTION_INIT EXCLUSIVE EXISTS EXIT
??? FALSE FETCH FILE FLOAT FOR FORM FROM FUNCTION
??? GENERIC GOTO GRANT GROUP
??? HAVING
??? IDENTIFIED IF IMMEDIATE IN INCREMENT INDEX INDEXES INDICATOR INITIAL INSERT INTEGER INTERFACE INTERSECT INTO IS
??? LEVEL LIKE LIMITED LOCK LONG LOOP
??? MAX MAXEXTENTS MIN MINEXTENTS MINUS MISLABEL MOD MODE
??? NATURAL NATURALN NEW NEXTVAL NOAUDIT NOCOMPRESS NOLOGGING NOT NOWAIT NULL NUMBER NUMBER_BASE
??? OF OFFLINE ON ONLINE OPEN OPTION OR ORDER OTHERS OUT
??? PACKAGE PARTITION PCTFREE PCTUSED PLS_INTEGER POSITIVE POSITIVEN PRAGMA PRIOR PRIVATE PRIVILEGES PROCEDURE PUBLIC
??? RAISE RANGE RAW REAL RECORD REF RELEASE REMR RENAME RESOURCE RETURN REVERSE REVOKE ROLLBACK ROW ROWID ROWLABEL ROWNUM ROWS ROWTYPE RUN
??? SAVEPOINT SCHEMA SELECT SEPARATE SESSION SET SHARE SMALLINT SPACE SQL SQLCODE SQLERRM START STATEMENT STDDEV SUBTYPE SUCCESSFUL SUM SYNONYM SYSDATE
??? TABAUTH TABLE TABLES TASK TERMINATE THEN TO TRIGGER TRUE TYPE
??? UID UNION UNIQUE UPDATE USE USER
??? VALIDATE VALUES VARCHAR VARCHAR2 VARIANCE VIEW VIEWS
??? WHEN WHENEVER WHERE WHILE WITH WORK WRITE
??? XOR
/C2 "Packages"
??? DBMS_OUTPUT DBMS_JOB DBMS_SQL
/C3 "Package Methods"
??? 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
??? PARSE PUT PUT_LINE
??? REMOVE
??? SUBMIT
??? WHAT
/C4 "SQL*Plus Commands"
??? EXECUTE
??? GRANT
??? REPLACE
??? RUN
??? START
??? EXCEPTION
/C5 "SQL*Plus Functions"
??? ABS ADD_MONTHS ASCII
??? CEIL CHR CONCAT CONVERT COS COSH
??? DECODE?
??? EXP?
??? FLOOR
??? GREATEST
??? HEXTORAW
??? INITCAP INSTR
??? LAST_DAY LENGTH LN LOG LOWER LPAD LTRIM
??? MOD MONTHS_BETWEEN
??? NEXT_DAY NEW_TIME NLS_INITCAP NLS_LOWER NLS_UPPER NVL
??? POWER
??? RAWTOHEX REPLACE ROUND ROWIDTOCHAR RPAD RTRIM
??? 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
/C6 "Should Be Reserved"
??? BEFORE
??? EACH
??? FOR
??? KEY
??? PRIMARY
??? WHEN WHERE WHILE
?
??? 注意：每個(gè)字母一行，且不可用tab鍵移位(空格可以)
?
??? 重啟UE，高級(jí)-配置-編輯器顯示-語(yǔ)法加亮-PLSQL，將對(duì)應(yīng)的模塊設(shè)置需要的顏色及字體。
?
??? 保存后設(shè)置完成。
?
?