Question:

I am trying to insert a string with a single quote inside, but
it fails. Please advise how do I tackle this problem.

eg:- insert into tmp values ('table's');
I am not supposed to change the single quote to a double quote
for eg: insert into tmp values ('table"s');

Answer:

insert into tmp values ('table''s');

Note: between word table and s is not a double quote, but two single quotes.