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

Home -> Community -> Usenet -> c.d.o.tools -> Insert single quote

Insert single quote

From: Marty Provost <liquidgolf_at_earthlink.net>
Date: 2000/04/18
Message-ID: <kG3L4.61705$q67.917595@newsread2.prod.itd.earthlink.net>#1/1

Stupid question...

What's the syntax to insert a string that contains a single quote?

Example:

TABLENAME
columnname varchar2(100)

insert into tablename (columname)
values ('help me insert this ' into this column');

Thanks in advance,
Marty Received on Tue Apr 18 2000 - 00:00:00 CDT

Original text of this message

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