Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: inserting a ' (apostrophe) in a table

Re: inserting a ' (apostrophe) in a table

From: Ken Geis <kgeis_at_cchemnt.cchem.berkeley.edu>
Date: Mon, 16 Nov 1998 14:30:56 -0800
Message-ID: <3650A7A0.E8A1A8B@cchemnt.cchem.berkeley.edu>

        If that's just an apostrophe to insert into a column, you would say:

INSERT INTO my_table (some_column)
VALUES (''''); That would be "open quote", "escaped quote", "close quote."

Ken

Jeff Howey wrote:
>
> Hi! I need to know how to insert a ' into a table field... i've tried
> using a double and it didn't work... any hints?
Received on Mon Nov 16 1998 - 16:30:56 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US