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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Inserting single quotes into database

Re: Inserting single quotes into database

From: Arjan van Bentem <avbentem_at_DONT-YOU-DAREdds.nl>
Date: Fri, 12 Mar 1999 18:44:12 +0100
Message-ID: <36e9526e$0$2617@newton>


sannarayan wrote
>Can anyone please tell me how to insert
>a single quote (" ' ")into an oracle table.

You need to type them twice. Two single quotes within a string tell Oracle to use it a a single qoute, not as the string terminator. Like 'ab''cd' gets you ab'cd and '''' gets you '.

Arjan. Received on Fri Mar 12 1999 - 11:44:12 CST

Original text of this message

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