Decode360's Blog

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

            BlogJava :: 首頁 :: 新隨筆 :: 聯系 ::  :: 管理 ::
            302 隨筆 :: 26 文章 :: 82 評論 :: 0 Trackbacks
          ??? 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,將對應的模塊設置需要的顏色及字體。
          ??? 保存后設置完成。
          ?

          ?




          -The End-

          posted on 2009-03-31 23:50 decode360-3 閱讀(694) 評論(0)  編輯  收藏 所屬分類: The Others
          主站蜘蛛池模板: 兴国县| 鄢陵县| 南丹县| 东至县| 南雄市| 滦南县| 乌恰县| 沙雅县| 栖霞市| 多伦县| 神农架林区| 新竹县| 汝州市| 巩留县| 江都市| 祁东县| 石楼县| 夏邑县| 大丰市| 新安县| 永嘉县| 通江县| 琼中| 南华县| 玛多县| 鄂托克旗| 涿鹿县| 当涂县| 淮安市| 尉犁县| 措勤县| 宁南县| 湖州市| 台中市| 泾阳县| 馆陶县| 漯河市| 盐亭县| 宝山区| 岳阳县| 砚山县|