Apostrophe in Sql [message #18875] |
Tue, 19 February 2002 18:46 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Shirish
Messages: 2 Registered: February 2002
|
Junior Member |
|
|
Hi,
Can anyone help me how to select an apostrophe in a select statement.
eg: I want to select the text
This is Shirish's HomePage.
in Oracle.
Please help.
|
|
|
Re: Apostrophe in Sql [message #18881 is a reply to message #18875] |
Tue, 19 February 2002 23:33 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
saquibzaheer
Messages: 3 Registered: February 2002
|
Junior Member |
|
|
FOr reteriving
select * from emp
where ename like '%''%'
for inserting
insert into emp
(empno ,mgr,deptno,ename)
values ( '111',7369,10,'saq''s')
|
|
|
|
|