Path: utzoo!attcan!uunet!cs.utexas.edu!usc!apple!oracle!news
From: mfriedma@oracle.com (Michael Friedman)
Newsgroups: comp.databases
Subject: Re: Easy Oracle question
Message-ID: <1990Jun13.123325.26485@oracle.com>
Date: 13 Jun 90 12:33:25 GMT
References: <47469@iuvax.cs.indiana.edu} <176@twg.UUCP}
Reply-To: mfriedma@oracle.UUCP (Michael Friedman)
Organization: Oracle Corporation, Belmont, CA
Lines: 23

In article <176@twg.UUCP} bill@.UUCP (Bill Irwin) writes:
}In article <47469@iuvax.cs.indiana.edu} bbeckman@silver.ucs.indiana.edu (Beth Beckman) writes:
}}I am trying to load a row in an Oracle table using the insert command.
}}My question is: how do you format the command to insert a value
}}containing an apostrophe?  Example: Insert into tablename values
}}('President's Office').  Obviously, it is interpreting the apostrophe
}}after the 't' as the end of the field.  Thanks for your assistance!

}Have you tried escaping the quote?
}('President\'s Office')

This might work (I haven't checked) but I know that doubling the
apostrophe will work.

('President''s Office')

Mike Friedman, and no - I don't speak for Oracle.

--
The passing of Marxism-Leninism first from China and then from the
Soviet Union will mean its death as a living ideology ... .  For while
there may be some isolated true believers left in places like Managua,
Pyongyang, or Cambridge, MA ...   - Francis Fukuyama