Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: inserting a ' (apostrophe) in a table
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