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 -> single quote

single quote

From: Ong Chin Hui <chong_at_singaport.gov.sg>
Date: 1997/10/21
Message-ID: <344c0344.72812422@news.pacific.net.sg>#1/1

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 ? Received on Tue Oct 21 1997 - 00:00:00 CDT

Original text of this message

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