sqlterminator
?
?
SQLPLUS的sqlterminator參數可以在后面跟3個東西，分別是ON、OFF和character
?
SQL> set sqlterminator ON|OFF|c
?
c specifies the character that ends an SQL statement. The default is the semicolon (;).
The sqlterminator cannot be alpha numeric.
?
?
舉例如下：
?
SQL> set sqlterminator off
SQL> show sqlterminator
sqlterminator OFF
SQL> select * from dual
? 2? ;
? 3? /
;
*
ERROR at line 2:
ORA-00911: invalid character
SQL> select * from dual
? 2? /
?
D
-
X
?
--關閉之后僅能以"/"來執行該SQL語句
?
SQL> set sqlterminator on
SQL> show sqlterminator
sqlterminator ";" (hex 3b)
SQL> select * from dual
? 2? ;
?
D
-
X
?
--打開后默認以";"來結尾
?
SQL> set sqlterminator !
SQL> show sqlterminator
sqlterminator "!" (hex 21)
SQL> select * from dual !
?
D
-
X
?
--設置其他字符作為sqlterminator
?
SQL> set sqlterminator on
SQL> show sqlterminator
sqlterminator ";" (hex 3b)
?
--設置on之后，依舊改為默認結束代碼";"
?
SQL> set sqlterminator OFF
SQL> update T1
? 2? set A =
? 3? 'DECLARE
? 4? RID NUMBER := 0 ;
? 5? BEGIN
? 6? SELECT 1 INTO RID
? 7? FROM dual;
? 8? END ;'
? 9? where B= 'xxxx'
10? /
1 row updated.
SQL> commit
? 2? /
Commit complete.
SQL> set sqlterminator ON
?
--應用(插入帶";"的字符串)
?
?
?
?
?
escape
?
SQLPLUS的escape參數后面可以跟4個東西，分別是ON、OFF、character和"\"
?
SQL> SET ESC[APE] {\| c|ON|OFF}
Defines the character you enter as the escape character. OFF undefinesthe escape character. ON enables the escape character. ON changes thevalue of c back to the default "\".
?
?
簡單舉例：
?
SQL> set escape on
SQL> show escape
escape "\" (hex 5c)
SQL> select '\' from dual;
'
-
SQL> select '\\' from dual;
'
-
\
SQL> select '\\\' from dual;
'
-
\
SQL> select '\\\\' from dual;
'\
--
\\
?
--"\"為轉義符，轉移任意一個它后面的字符
?
SQL> set escape !
SQL> select '\\' from dual;
?
'\
--
\\
?
SQL> select '!\' from dual;
?
'
-
\
?
--使用其他字符作為轉義
?
?
?
注意：這里的escape參數與SQL中的escape函數完全不同
?
?
?