Re: single quote

From: gsp13 sunpeak13 <peak12_at_sunpeak12.ebay.sun.com>
Date: 1997/10/30
Message-ID: <345927EE.33412C93@sunpeak12.ebay.sun.com>#1/1

Ong Chin Hui wrote:
>
> Hi, I am using Java and Oracle RDBMS.
>
> When forming the SQL statements for call to Oracle, some statements
> cause error because of existence of single quote in some columns.
>
> Eg. insert into COMPANY values ( 'SAN'ANGLE', ... )
>
> Instead of scanning for single quote, is there any easy way out ?

Duplicate the quote inside the string e.g 'SAN''ANGLE' Received on Thu Oct 30 1997 - 00:00:00 CST