What you want to do is insert the data in the database with the ' replaced with '' . This escapes the apostrophe and won't mess up the query.

JSON has stolen some of XML's thunder with features such as human and machine readability, a lightweight, compact text structure and support for many software and hardware platforms. JSON (JavaScript ...

JSON has stolen some of XML's thunder with features such as human and machine readability, a lightweight, compact text structure and support for many software and hardware platforms. JSON (JavaScript ...

Oracle SQL string functions have included the Soundex function for a long time. Soundex is a phonetic normalization function that was invented for the 1880 U.S. Census to get around the problem of ...