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 quote into column

Re: inserting quote into column

From: Tom Mettling <mettlingt_at_wtchen.com>
Date: 1997/06/13
Message-ID: <33A18F47.1629D40@wtchen.com>#1/1

Ron,

Use the chr() function. The single quote is chr(39), so it would be Master' || chr(39) || 's', or something like that.

Hope this helps,

Tom Mettling
W.T. Chen & Company, Inc.
mettlingt_at_wtchen.com

Ron Heeb wrote:

> the following insert gives me an error because i am trying to include
> a
> single quote within the string:
>
> insert into xxx values ('13','A','28',
> ' COMPLETE THE YELLOW APPLICATION FOR MASTER'S DEGREE AND
> DIPLOMA','ADREC
> ');
>
> is there a way to insert a single quote? since i'm going on vacation
> it
> might be best to send an email as well as posting the response. thanks
> in
> advance, ron
>
> --
> Ron Heeb, Webmaster
> Mgr., Applications Development, ITR
> California State University, Northridge
> email: ron.heeb_at_csun.edu, webmaster_at_csun.edu
Received on Fri Jun 13 1997 - 00:00:00 CDT

Original text of this message

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