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...:-(