Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!tut.cis.ohio-state.edu!ucbvax!van-bc!twg!bill
From: bill@twg.UUCP (Bill Irwin)
Newsgroups: comp.databases
Subject: Re: Easy Oracle question
Message-ID: <176@twg.UUCP>
Date: 13 Jun 90 07:53:52 GMT
References: <47469@iuvax.cs.indiana.edu>
Reply-To: bill@.UUCP (Bill Irwin)
Organization: TWG The Westrheim Group, Vancouver BC
Lines: 14
Summary:
Expires:
Sender:
Followup-To:
Distribution:
Keywords:

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')
-- 
Bill Irwin - TWG The Westrheim Group - Vancouver, BC, Canada
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
uunet!van-bc!twg!bill     (604) 431-9600 (voice) |     UNIX Systems
Bill.Irwin@twg.UUCP       (604) 431-4629 (fax)   |     Integration