在plsql裡邊執行:
update userinfo set pageurl=
其中||是連字符
plsql中還可以set define off來關閉特殊字符
select
insert into t(col) values(chr(ascii(
(方法一)
例:插入特殊字元
SQL> SHOW DEFINE
define
SQL> SET DEFINE OFF
(方法二)
SQL> SHOW ESCAPE
escape OFF <
SQL> SET ESCAPE ON
SQL> SHOW ESCAPE
escape
SQL> INSERT INTO temp_table VALUES (
From:http://tw.wingwit.com/Article/program/Oracle/201311/17018.html