Escape single quotes

[Sandeep Advani]

Hello Friends

I have a cursor which reads columns FirstName and LastName from table A into 2 variables which is then used to insert their values in Table 2. The insert statement is first constructed as a String. Unfortunately some of these values have a single-quote already in them; hence string construction surrounded by single-quotes fails for certain records. Double-quotes does not work either.

Is there any workaround to escape single-quotes in the names values?

Thanks
Sandeep

PS: Google could not provide much details either...I am sure my keywords were not right...:-(

[Sandeep Advani]

Nevermind - I got it using the Oracle replace function.
Replaced single quotes with double.

[Jeanne Boyarsky]

Sandeep,
Also a PreparedStatement will handle the escaping for you if going through JDBC.