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?
PS: Google could not provide much details either...I am sure my keywords were not right...:-(
posted 14 years ago
Nevermind - I got it using the Oracle replace function. Replaced single quotes with double.