Decode360's Blog

业精于勤而荒于嬉 QQ:150355677 MSN:decode360@hotmail.com

  BlogJava :: 首页 :: 新随笔 :: 联系 ::  :: 管理 ::
  397 随笔 :: 33 文章 :: 29 评论 :: 0 Trackbacks
在UE中设置PLSQL的加亮模式
 
    UE默认的安装中是没有PLSQL的显示模式的(至少我安装的版本没有),所以需要自己手动进行设置,设置方法如下:
 
    首先,打开UE的格式配置文档   C:\Program Files\IDM COMPUTER SOLUTIONS\ULTRAEDIT-32\wordfile.txt
    这个文件是安装之后默认配置文件,当然也可以自己指定位置。
 
    然后在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
 
    注意:每个字母一行,且不可用tab键移位(空格可以)
 
    重启UE,高级-配置-编辑器显示-语法加亮-PLSQL,将对应的模块设置需要的颜色及字体。
 
    保存后设置完成。
 

 
posted on 2009-03-31 23:50 decode360 阅读(2377) 评论(0)  编辑  收藏 所属分类: 16.Others

只有注册用户登录后才能发表评论。


网站导航: