create table test (str varchar2(200));insert into test values ('"<a href=''#''>;&*;;</a>"'); commit; select * from test;STR -------------------------------------------------------------------------------- "<a href='#'>;&*;;</a>"
create table test123 (str varchar2(200));insert into test123 values ('<a href=''#''>;&*;;</a>'); insert into test123 values ('"<a href=''#''>;&*;;</a>"');commit; select * from test123; STR ----------------------- <a href='#'>;&*;;</a> "<a href='#'>;&*;;</a>"
insert into OA_MEETROOM(SID,NAME,PLACE,CONTAIN,MRESOURCE,NOTE) values ('XXXXX128747981520311','会议室','10','10','10','<a href='#'>ss</a>')Tue Oct 19 17:16:55 CST 2010 | [异常代码:DC-04] 执行SQLS出现异常。java.sql.SQLException: ORA-00911: 无效字符如何解决???????
insert into OA_MEETROOM(SID,NAME,PLACE,CONTAIN,MRESOURCE,NOTE) values ('XXXXX128747981520311','会议室','10','10','10','<a href=''#''>ss</a>')
insert into OA_MEETROOM(SID,NAME,PLACE,CONTAIN,MRESOURCE,NOTE) values ('XXXXX128747981520311','会议室','10','10','10','<a href=''#''>ss</a>')
create table test (str varchar2(200));insert into test values ('"<a href=''#''>;&*;;</a>"');
commit;
select * from test;STR
--------------------------------------------------------------------------------
"<a href='#'>;&*;;</a>"
insert into test123 values ('"<a href=''#''>;&*;;</a>"');commit;
select * from test123;
STR
-----------------------
<a href='#'>;&*;;</a>
"<a href='#'>;&*;;</a>"
insert into OA_MEETROOM(SID,NAME,PLACE,CONTAIN,MRESOURCE,NOTE) values ('XXXXX128747981520311','会议室','10','10','10','<a href=''#''>ss</a>')
--你要插入"<a href='#'>;&*;;</a>"
--就要转换成'"<a href=''#''>;&*;;</a>"'
SQL> insert into test values('"<a href=''#''>;&*;;</a>"');已创建 1 行。SQL> commit;提交完成。SQL> select * from test;COL1
-----------------------------------------------------------------
"<a href='#'>;&*;;</a>"