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 -> ' in dynamic sql

' in dynamic sql

From: Allan Martin <allan.martin_at_saic.com>
Date: Thu, 6 Dec 2001 14:56:40 -0000
Message-ID: <3c0f16aa@cpns1.saic.com>


Hi,

I have got a dynamic SQL statement which when build, the data which is going to be inserted into a table, may have the ' symbol in it. This means that when I'm executing my SQL statement, the string is ended by the rouge ' . Can anyone suggest anything?

Allan Received on Thu Dec 06 2001 - 08:56:40 CST

Original text of this message

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