Oracle common errors (ORA-01756: strings in quotes do not end properly)

Oracle common errors (ORA-01756: strings in quotes are not properly ended) today while testing the import of data, the first few tests have been good not encountered problems, but then added a sentence in English, then an exception is reported. Www.2cto.com is used to test the import of the execl document. The question is "Don't give up your dream, keep sleeping .". Later, I changed this sentence to "Don't give up your dream, keep sleeping. Then we can read it out, "Don't give up your dream, keep sleeping. the reason is that when you see the first "'" in the database insert statement, it will be considered as the start of the string, and the last "'" will be considered as the end ID of the string. So an error occurred. The solution is to meet a string with "'" and add a "'" after the "'" symbol. This is only the current solution, waiting for a better solution. Error