Re: apostrophes in an SELECT SQL statement

From: Scott Urman <surman_at_dlsun338.us.oracle.com>
Date: 1996/07/19
Message-ID: <4smm51$kql_at_inet-nntp-gw-1.us.oracle.com>#1/1

In article <31EE9638.7AF9_at_ssi.sony.com>, Jason Byors <jbyors_at_ssi.sony.com> writes:
|> How could the following SELECT SQL statement be written so that it
|> will work:
|>
|> SELECT * FROM movies WHERE title = 'Muriel's Wedding'

Inside a SQL statement, use two single quotes next to each other. You would do this with

SELECT * FROM movies WHERE title = 'Muriel''s Wedding'

|>
|> The apostrophe in the word Muriel's is not allowing this statement to
|> be processed. Is there any way to make such a statement work, or
|> would I have to remove all the apostrophes from my table?
|>
|> Thank you for your help,
|> jb

---

Scott Urman Oracle Corporation surman_at_us.oracle.com

---

Author of _Oracle PL/SQL Programming_ ISBN 0-07-882176-2 Published by Oracle Press - http://www.osborne.com/oracle/index.htm

---

"The opinions expressed here are my own, and are not necessarily that of  Oracle Corporation"

---

Received on Fri Jul 19 1996 - 00:00:00 CEST