OraFAQ Forum: SQL & PL/SQL » Apostrophe in Sql

Home » SQL & PL/SQL » SQL & PL/SQL » Apostrophe in Sql

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Apostrophe in Sql [message #18875]

Tue, 19 February 2002 18:46

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.

Report message to a moderator

Re: Apostrophe in Sql [message #18881 is a reply to message #18875]

Tue, 19 February 2002 23:33

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')

Report message to a moderator

Re: Apostrophe in Sql [message #18888 is a reply to message #18875]

Wed, 20 February 2002 03:43

Suresh Vemulapalli
Messages: 624
Registered: August 2000

Senior Member

Here is one more query:

select * from table1 where instr(col1,chr(39))>0;

Report message to a moderator

Re: Apostrophe in Sql [message #18905 is a reply to message #18875]

Wed, 20 February 2002 18:26

Sudhakar Atmakuru
Messages: 58
Registered: May 2001

Member

Try this out.

SELECT 'This is Shirish''s Homepage' FROM DUAL;

(Just precede one apostrophe with another)

Good luck.
:)

Report message to a moderator

Previous Topic:	append leading zero's to data already in columns
Next Topic:	Re: how to use audit command

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 16:38:20 CDT 2024