国产一级a片免费看高清,亚洲熟女中文字幕在线视频,黄三级高清在线播放,免费黄色视频在线看

打開(kāi)APP
userphoto
未登錄

開(kāi)通VIP,暢享免費(fèi)電子書(shū)等14項(xiàng)超值服

開(kāi)通VIP
Uedit32編輯器與SQLPlus結(jié)合使用技巧
用過(guò)Uedit32的人都知道,這個(gè)工具雖然小,卻功能俱全.只要我們?cè)诠ぷ髦星擅畹氖褂糜盟?可以使我們的工作效率事半功倍.那么,在下面的文章中,我將說(shuō)說(shuō)Uedit32與Oracle SQLPlus用法. 首先下載并安裝Uedit32,確保SQlPlus能正常運(yùn)行, 接下來(lái)的事情就是兩者的系統(tǒng)配置了,具體按照以下的幾個(gè)步驟進(jìn)行: 步驟一:在Oracle安裝目錄下的Ora81找到dbs這個(gè)文件夾,如果沒(méi)有這個(gè)文件夾,創(chuàng)建名為dbs的文件夾,然后在這個(gè)文件夾下新建一個(gè)文本文件,取名為:login.sql.步驟二:在Uedit32的安裝目錄下新建一個(gè)文本文件,取名為:PlSQL.txt步驟三:打開(kāi)Uedit32,在Uedit32主菜單的Advanced下,選擇Configuration...進(jìn)入到一個(gè)頁(yè)面UltraEdit Configuration.在這個(gè)
頁(yè)面中選擇Syntax Highlighting,在Full path name for中,將你第二步創(chuàng)建的Plsql.txt連接到此,即,單擊Browse,直接在Uedit32目錄下找到Plsql.txt這個(gè)文件,確定后,一切就ok了。步驟四:在Uedit32主菜單的View下的View AS(Highlightiing File Type)下會(huì)顯示一個(gè)SQL,這樣就說(shuō)明你的Configuration已經(jīng)Succeed.如果在這個(gè)菜單下沒(méi)有SQL,就說(shuō)明Configuration錯(cuò)誤,重復(fù)上邊的步驟,直到出現(xiàn)SQL為止。*****如果配置成功后,每次在SQLPlus下進(jìn)行SQL語(yǔ)句編輯的時(shí)候,要對(duì)已經(jīng)編輯或執(zhí)行的SQL語(yǔ)句修改,就可以直接輸入ED即可進(jìn)入到Uedit32的編輯狀態(tài),這樣,大大方便了使用速度.
另附:login.sql文件腳本:
define _editor='uedit32.exe' set editfile a.sql set line 1000
說(shuō)明:PlSQL.txt腳本主要用來(lái)控制 SQL語(yǔ)句在uedit32中字體顯示顏色,變量名,函數(shù)名等將以不同的顏色進(jìn)行顯示,方便修改和辨認(rèn)。
網(wǎng)上最全的UltraEdit-32語(yǔ)言著色配置文件,將近600種語(yǔ)言的著...原文鏈接
/L20"PL/SQL for Oracle8i" Nocase Line Comment = -- Line Comment Alt = REM Block Comment On = /* Block Comment Off = */ String Chars = ' File Extensions = SQL /Delimiters = ~!%@^&*()-+=|\/{}[]:;"'<> , .?/Function String = "%[A-Z _]*[~\s]+(*)"/Function String 1 = "% ++^(^{FUNCTION^}^{PROCEDURE^} [A-Z _ 0-9 a-z]+*^)"/Function String 2 = "% ++^(CURSOR [A-Z _ 0-9 a-z]+ ^)+IS"/Indent Strings = "THEN" "LOOP" "ELSE" "BEGIN" "IS" "EXCEPTION" "ELSIF"/Unindent Strings = "END IF;" "END LOOP;" "END;" "ELSE" "ELSIF"/C1"Keywords"ABORT ACCEPT ACCESS ADD ALL ALTER AND ANY ARRAY ARRAYLEN AS ASC ASSERT ASSIGN AT ATTRIBUTES AUDIT AUTHORIZATION AVGBASE_TABLE BEGIN BETWEEN BINARY_INTEGER BODY BOOLEAN BYCASE CAST CHAR CHAR_BASE CHECK CLOSE CLUSTER CLUSTERS COLAUTH COLUMN COMMENT COMMIT COMPRESS CONNECT CONNECTED CONSTANT CONSTRAINT CRASH CREATE CURRENT CURRVAL CURSORDATABASE DATA_BASE DATE DBA DEALLOCATE DEBUGOFF DEBUGON DECLARE DECIMAL DEFAULT DEFINITION DELAY DELETE DESC DIGITS DISPOSE DISTINCT DO DROPELSE ELSIF ENABLE END ENTRY ESCAPE EXCEPTION EXCEPTION_INIT EXCHANGE EXCLUSIVE EXISTS EXIT EXTERNALFAST FETCH FILE FOR FORCE FORM FROM FUNCTIONGENERIC GOTO GRANT GROUP HAVINGIDENTIFIED IF IN INCREMENT INDEX INDEXES INDICATOR INITIAL INITRANS INSERT INTERFACE INTERSECT 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 OFF OFFLINE ON ONLINE ONLY OPEN OPTION OR ORDER OUTPACKAGE PARALLEL PARTITION PCTFREE PCTINCREASE PCTUSED PLS_INTEGER POSITIVE POSITIVEN PRAGMA PRIMARY PRIOR PRIVATE PRIVILEGES PROCEDURE PUBLICRAISE RANGE RAW READ REBUILD RECORD REF REFERENCES REFRESH RELEASE REMR RENAME REPLACE RESOURCE RESTRICT RETURN RETURNING REVERSE REVOKE ROLLBACK ROW ROWID ROWLABEL ROWNUM 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 UNLIMITED UNRECOVERABLE UNUSABLE UPDATE USE USINGVALIDATE VALUE VALUES VARIABLE VIEW VIEWSWHEN WHENEVER WHERE WHILE WITH WORK/C2"Functions"ACOS ABS ADD_MONTHS ASCII ASIN ATAN ATAN2 AVERAGE BFILENAMECEIL CHR CHARTOROWID CONCAT CONVERT COS COSH COUNT DECODE DEREF DUAL DUMP DUP_VAL_ON_INDEXEMPTY ERROR EXPFALSE FLOOR FOUNDGLB GREATESTHEXTORAWINITCAP INSTR INSTRB ISOPENLAST_DAY LEAST LENGHT LENGHTB LN LOWER LPAD LTRIM LUBMAKE_REF MAX MIN MOD MONTHS_BETWEENNEW_TIME NEXT_DAY NEXTVAL NLS_CHARSET_DECL_LEN NLS_CHARSET_ID NLS_CHARSET_NAME NLS_INITCAP NLS_LOWER NLS_SORT NLS_UPPER NLSSORT NO_DATA_FOUND NOTFOUND NULL NVLOTHERSPOWERRAWTOHEX REFTOHEX ROUND ROWCOUNT ROWIDTOCHAR 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/C3"SQLPlus"BREAKCOMPUTEECHO EXEC EXECUTEPAGESIZESERVEROUTPUT SHOW SIZE SPOOLTERM TIMIN/C4"Types"BFILE BLOBCHARACTER CLOBDEC FLOATINT INTEGERMLSLABELNATURAL NATURALN NCHAR NCLOB NUMBER NUMERIC NVARCHAR2REAL ROWTYPESIGNTYPE SMALLINT STRINGVARCHAR VARCHAR2/C5"Packages"ADD_SUBSCRIBER ALLOCATE_UNIQUE ALLOW_ALL ALLOW_SERVER ALTER_QUEUE APPENDBIND_ARRAY BIND_INOUT_VARIABLE BIND_OUT_VARIABLE BIND_VARIABLE BIND_VARIABLE_CHAR BIND_VARIABLE_RAW BIND_VARIABLE_ROWID BROKENCHANGE CLOSE_CURSOR COLUMN_VALUE COLUMN_VALUE_CHAR COLUMN_VALUE_LONG COLUMN_VALUE_RAW COLUMN_VALUE_ROWID 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_EXTPROC DMBS_HS_PASSTHROUGH DBMS_JOB DBMS_LOB DBMS_LOCK DBMS_OUTPUT DBMS_PIPE DBMS_REFRESH DBMS_REPCAT DBMS_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_SERVER DEQUEUE_OPTIONS_T DESCRIBE_COLUMNS DESCRIBE_PROCEDURE DISABLE DROP_INST_INIT DROP_QUEUEENQUEUE ENQUEUE_OPTIONS_T ERASE EXECUTE_AND_FETCH EXECUTE_INMEDIATE EXECUTE_NON_QUERYFETCH_ROW FETCH_ROWS FILECLOSE FILECLOSEALL FILEEXISTS FILEGETNAME FILEISOPEN FILEOPENGET_LINE GET_LINES GET_VALUE GETLENGTHINTERVAL IS_OPENKEEPLAST_ERROR_POSITION LAST_ROW_COUNT LAST_ROW_ID LAST_SQL_FUNCTION_CODE LOAD_FROM_FILEMESSAGE_PROPERTIES_TNEW_LINE NEXT_DATE NEXT_ITEM_TYPEOPEN_CURSORPACK_MESSAGE PARSE PURGE PUT PUT_LINEQUEUE_SUBSCRIBERSREAD_CLIENT_INFO READ_MODULE RECIEVE_MESSAGE REGISTER REMOVE REMOVE_PIPE REMOVE_SUBSCRIBER REQUEST REQUEST_PIECES RESET_BUFFER ROWID_BLOCK_NUMBER ROWID_CREATE ROWID_INFO ROWID_OBJECT ROWID_RELATIVE_FNO ROWID_TO_ABSOLUTE_NFO ROWID_TO_EXTENDED ROWID_TO_RESTRICTED ROWID_TYPE ROWID_VERIFY SCHEDULE_PROPAGATION SEND_MESSAGE SET_ACTION SET_CLIENT_INFO SET_DEFAULTS SET_MODULE SET_SQL_TRACE SET_SQL_TRACE_IN_SESSION SIGNAL SIZES SLEEP START_QUEUE STOP_QUEUE SUBMITTRIMUNIQUE_SESSION_NAME UNKEEP UNPACK_MESSAGE UNSCHEDULE_PROPAGATION UTL_HTTPVARIABLE_VALUE VERIFY_QUEUE_TYPESWAITANY WAITONE WHAT WRITE/C6"Operators"@+-=:><|.,;! ...
本站僅提供存儲(chǔ)服務(wù),所有內(nèi)容均由用戶發(fā)布,如發(fā)現(xiàn)有害或侵權(quán)內(nèi)容,請(qǐng)點(diǎn)擊舉報(bào)。
打開(kāi)APP,閱讀全文并永久保存 查看更多類(lèi)似文章
猜你喜歡
類(lèi)似文章
T-SQL的回車(chē)和換行符(SQL)
Oracle入門(mén)教學(xué)
oracle之spool詳細(xì)使用總結(jié)
Mysql UDF
Download jQuery | jQuery
去除 字符串中空格/回車(chē)(資料收集未整理)
更多類(lèi)似文章 >>
生活服務(wù)
分享 收藏 導(dǎo)長(zhǎng)圖 關(guān)注 下載文章
綁定賬號(hào)成功
后續(xù)可登錄賬號(hào)暢享VIP特權(quán)!
如果VIP功能使用有故障,
可點(diǎn)擊這里聯(lián)系客服!

聯(lián)系客服