用转义字符例如:select p_name, p_id from products where p_name like '/%scott' escape '/'; select * from table1 where id='A/'' escape '/';
oracle10g,用q'[]'或q'{}'等select q'[A']' from dual; select q'{A'}' from dual; select q'!A'!' from dual;oracle9i以前,则用''代替一个',如 select 'A''' from dual;
也就是说 select * from table1 where id='A'||'''' 或者: select * from table1 where id='A'|| chr(39)
如果你想具体的了解转义字符的使用 可以自己上GOOGLE去查询,信息很多的:)
select * from table1 where id='A'''
create table tt(name varchar(10)) insert into tt select 'a' from dual insert into tt select 'a''' from dualselect * from tt where name=q'[a']' --- name a' -----
select q'[a']',q'{a'}',q'(a')',q'"a'"' ,q'!a'!' from dual
where p_name like '/%scott' escape '/';
select * from table1 where id='A/'' escape '/';
select q'{A'}' from dual;
select q'!A'!' from dual;oracle9i以前,则用''代替一个',如
select 'A''' from dual;
select * from table1 where id='A'||''''
或者:
select * from table1 where id='A'|| chr(39)
create table tt(name varchar(10))
insert into tt select 'a' from dual
insert into tt select 'a''' from dualselect * from tt
where name=q'[a']'
---
name
a'
-----