Home » SQL & PL/SQL » SQL & PL/SQL » Names with single quotation marks
Names with single quotation marks [message #2784] Tue, 13 August 2002 06:56 Go to next message
Jen
Messages: 23
Registered: June 2001
Junior Member
Is there a way to get Oracle to recognise a single quotation mark as a literal value instead of a signal to close the statment... for exmample if you had a name like Paul O' Brian and wanted to do a search on it what would your SQL look like?

Report message to a moderator

Re: Names with single quotation marks [message #2785 is a reply to message #2784] Tue, 13 August 2002 07:17 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Wrote file afiedt.buf

1* select ('Paul O'' Brian') from dual
local@ >/

('PAULO''BRIAN
--------------
Paul O' Brian

Report message to a moderator

Previous Topic: query for date comparison
Next Topic: Re: date range
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Apr 24 09:49:56 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.