Uedit32编辑器与SQLPlus结合使用技巧

1、Uedit32 编辑器与 SQLPlus 结合使用技巧用过 Uedit32 的人都知道 ,这个工具虽然小 ,却功能俱全 . 只要我们在工作中巧妙的使用用它,可以使我们的工作效率事半功倍 .那么 ,在下面的文章中 ,我将说说 Uedit32 与 Oracle SQLPIus用法.首先下载并安装 Uedit32,确保SQIPIus能正常 运行 , 接下来的事情就是两者的系统配置了,具体按照以下的几个步骤进行 :步骤一：在 OracIe 安装目录下的 Ora81 找到 dbs 这个文件夹， 如果没有这个文件夹，创建名为 dbs 的文件夹，然后在这个 文件夹下新建一个文本文件，取名为： Iogin.s

2、qI. 步骤二：在 Uedit32 的安装目录下新建一个文本文件， 取名为： PISQL.txt 步骤三：打开 Uedit32，在Uedit32主菜单的 Advanced下， 选择 Configuration. 进入到一个页面 UItraEditConfiguration 在这个页面中选择 Syntax HighIighting, 在 FuII path name for 中，将你第二步创建的 PIsqI.txt 连接到此，即，单击Browse，直接在 Uedit32目录下找到 Plsql.txt这个文件，确 定后，一切就 ok 了。步骤四：在 Uedit32 主菜单的 View 下 的 Vi

3、ewAS(Highlightiing FileType）下会显示一个SQL,这样就说明你的 Configuration已 经Succeed如果在这个菜单下没有 SQL ,就说明Configuration 错误，重复上边的步骤，直到出现 SQL 为止。 * 如果配 置成功后 ,每次在 SQLPlus 下进行 SQL 语句编辑的时候 ,要对 已经编辑或执行的 SQL 语句修改 ,就可以直接输入 ED 即可 进入到Uedit32的编辑状态，这样，大大方便了使用速度.另附： login.sql 文件脚本：define_editor='uedit32.exe' set editfile

4、a.sql set line1000说明： PlSQL.txt 脚本主要用来控制SQL 语句在 uedit32 中字体显示颜色，变量名，函数名等将 以不同的颜色进行显示，方便修改和辨认。网上最全的UltraEdit-32 语言着色配置文件，将近 600 种语言的着 .原文 链接/L20"PL/SQL for Oracle8i" Nocase Line Comment = - LineComment Alt = REM Block Comment On = /* Block CommentOff = */ String Chars = ' File Extension

5、s = SQL/Delimiters =!八&*()-+=|V:;"' ,.?/Function String = "%A-Z _*s+(*)"/Function String 1 = "%+A(AFUNCTIONAAPROCEDUREA A-Z _ 0-9 a-z+*A)" /Function String 2 = "% +a(CURSOR A-Z _ 0-9 a-z+ a)+|S" /Indent Strings = "THEN" "LOOP" "ELSE

6、" "BEGIN" "IS" "EXCEPT|ON" "ELS|F"/Unindent Strings = "END |F;" "END LOOP;" "END;" "ELSE" "ELS|F"/C1"Keywords"ABORT ACCEPT ACCESS ADD ALL ALTER AND ANY ARRAY ARRAYLEN AS ASC ASSERT ASS|GN AT ATTR

7、|BUTES AUD|T AUTHOR|ZAT|ON A VG BASE_TABLE BEG|N BETWEEN B|NARY_|NTEGER BODY BOOLEAN BYCASE CAST CHAR CHAR_BASE CHECK CLOSE CLUSTER CLUSTERS COLAUTH COLUMN COMMENT COMM|T COMPRESS CONNECT CONNECTED CONSTANT CONSTRA|NT CRASH CREATE CURRENT CURRVAL CURSORDATABASE DATA_BASE DATE DBA DEALLOCATE DEBUGOFF

8、 DEBUGON DECLARE DEC|MAL DEFAULTDEF|N|T|ON DELAY DELETE DESC D|G|TS D|SPOSEDISTINCT DO DROPELSE ELSIF ENABLE END ENTRY ESCAPE EXCEPTION EXCEPTION_INIT EXCHANGE EXCLUSIVE EXISTS EXIT EXTERNALFAST FETCH FILE FOR FORCE FORM FROM FUNCTION GENERIC GOTO GRANT GROUPHAVINGIDENTIFIED IF IN INCREMENT INDEX IN

9、DEXESINDICATOR INITIAL INITRANS INSERT INTERFACEINTERSECT INTO IMMEDIATE ISKEYLEVEL LIBRARY LIKE LIMITED LOCAL LOCK LOG LOGGING LONG LOOPMASTER MAXEXTENTS MAXTRANS MEMBER MINEXTENTS MINUS MISLABEL MODE MODIFY MULTISETNEW NEXT NO NOAUDIT NOCOMPRESS NOLOGGING NOPARALLEL NOT NOWAIT NUMBER_BASEOBJECT OF

10、 OFF OFFLINE ON ONLINE ONLY OPEN OPTION OR ORDER OUTPACKAGE PARALLEL PARTITION PCTFREEPCTINCREASE PCTUSED PLS_INTEGER POSITIVE POSITIVEN PRAGMA PRIMARY PRIOR PRIV ATE PRIVILEGES PROCEDURE PUBLICRAISE RANGE RAW READ REBUILD RECORD REF REFERENCES REFRESH RELEASE REMR RENAME REPLACE RESOURCE RESTRICT R

11、ETURN RETURNING REVERSE REVOKE ROLLBACK ROW ROWID ROWLABELROWNUM ROWS RUNSAVEPOINT SCHEMA SEGMENT SELECT SEPARATE SESSION SET SHARE SNAPSHOT SPACE SQL SOME SPLIT START STATEMENT STORAGE SUBTYPE SUCCESSFUL SYNONYMTABAUTH TABLE TABLES TABLESPACE TASK TERMINATE THEN TO TRIGGER TRUNCATE TYPEUNION UNIQUE

12、 UNLIMITED UNRECOVERABLE UNUSABLE UPDATE USE USINGVALIDATE V ALUE V ALUES VARIABLE VIEW VIEWSWHEN WHENEVER WHERE WHILE WITH WORK /C2"Functions"ACOS ABS ADD_MONTHS ASCII ASIN ATAN ATAN2 AVERAGEBFILENAMECEIL CHR CHARTOROWID CONCAT CONVERT COSCOSH COUNTDECODE DEREF DUAL DUMP DUP_V AL_ON_INDEX

13、 EMPTY ERROR EXPFALSE FLOOR FOUNDGLB GREATESTHEXTORAWINITCAP INSTR INSTRB ISOPENLAST_DAY LEAST LENGHT LENGHTB LN LOWER LPADLTRIM LUBMAKE_REF MAX MIN MOD MONTHS_BETWEEN NEW_TIME NEXT_DAY NEXTV AL NLS_CHARSET_DECL_LEN NLS_CHARSET_ID NLS_CHARSET_NAME NLS_INITCAP NLS_LOWER NLS_SORT NLS_UPPER NLSSORT NO_

14、DATA_FOUND NOTFOUND NULL NVLOTHERSPOWERRAWTOHEX REFTOHEX ROUND ROWCOUNTROWIDTOCHAR RPAD RTRIMSIGN SIN SINH SQLCODE SQLERRM SQRT SOUNDEX STDDEV SUBSTR SUBSTRB SUM SYSDATETAN TANH TO_CHAR TO_DATE TO_LABEL TO_MULTI_BYTE TO_NUMBER TO_SINGLE_BYTE TRANSLATE TRUE TRUNCUID UPPER USER USERENVVARIANCE VSIZE/C

15、3"SQLPlus"BREAKCOMPUTEECHO EXEC EXECUTEPAGESIZESERVEROUTPUT SHOW SIZE SPOOLTERM TIMIN/C4"Types"BFILE BLOBCHARACTER CLOBDECFLOATINT INTEGERMLSLABELNATURAL NATURALN NCHAR NCLOB NUMBERNUMERIC NV ARCHAR2REAL ROWTYPESIGNTYPE SMALLINT STRINGVARCHAR V ARCHAR2/C5"Packages"ADD_S

16、UBSCRIBER ALLOCATE_UNIQUE ALLOW_ALLALLOW_SERVER ALTER_QUEUE APPENDBIND_ARRAY BIND_INOUT_V ARIABLEBIND_OUT_V ARIABLE BIND_V ARIABLEBIND_V ARIABLE_CHAR BIND_V ARIABLE_RAWBIND_V ARIABLE_ROWID BROKENCHANGE CLOSE_CURSOR COLUMN_V ALUECOLUMN_V ALUE_CHAR COLUMN_V ALUE_LONG COLUMN_V ALUE_RAW COLUMN_V ALUE_RO

17、WID COPY CREATE_INST_INIT CREATE_PIPE CREATE_QUEUE CREATE_QUEUE_TABLEDBMS_ALERT DBMS_APPLICATION_INFO DBMS_AQ DBMS_AQADM DBMS_DEFER DBMS_DEFER_QUERY DMBS_DEFER_SYS DBMS_DESCRIBE DBMS_DISTRIBUTED_TRUST_ADMIN DMBS_HS DMBS_HS_EXTPROCDMBS_HS_PASSTHROUGH DBMS_JOB DBMS_LOB DBMS_LOCK DBMS_OUTPUT DBMS_PIPE

18、DBMS_REFRESH DBMS_REPCATDBMS_REPCAT_ADMIN DBMS_REPCAT_AUTH DBMS_ROWID DBMS_SESSION DBMS_SHARED_POOL DBMS_SNAPSHOT DBMS_SQL DBMS_SPACE DBMS_SYSTEM DEFINE_ARRAY DEFINE_COLUMN DEFINE_COLUMN_CHAR DEFINE_COLUMN_LONG DEFINE_COLUMN_RAW DEFINE_COLUMN_ROWID DENY_ALL DENY_SERVERDEQUEUE_OPTIONS_T DESCRIBE_COLU

19、MNS DESCRIBE_PROCEDURE DISABLE DROP_INST_INIT DROP_QUEUEENQUEUE ENQUEUE_OPTIONS_T ERASEEXECUTE_AND_FETCH EXECUTE_INMEDIATE EXECUTE_NON_QUERYFETCH_ROW FETCH_ROWS FILECLOSE FILECLOSEALL FILEEXISTS FILEGETNAME FILEISOPEN FILEOPEN GET_LINE GET_LINES GET_V ALUE GETLENGTH INTERV AL IS_OPENKEEPLAST_ERROR_POSITION LAST_ROW_COUNTLAST_ROW_ID LAST_SQL_FUNCTION_CODE LOAD_FROM_FILEMESSAGE_PROPERTIES_TNEW_LINE NEXT_DATE NEXT_ITEM_TYPEOPEN_CURSORPACK_MESSAGE PARSE P