Insert special character statements in Oracle SQL

Oracle SQL INSERT special character statement for INSERT database data statement: INSERT INTO TESTTAB (FIELD1) VALUES ('test') if there are single quotation marks in the string inserted INTO the database, escape processing is required, insert "It's a tree. ", the SQL statement is as follows: INSERT INTO TESTTAB (FIELD1) VALUES ('it''s a dog. ') if the SQL statement contains "&", the subsequent strings are processed as a variable and cannot be inserted into the database normally. If you do need to INSERT & characters INTO the database, perform the following operations: insert into testtab (FIELD1) VALUES ('I work in R' |' & '| 'd. ') from Feng Yifei's column