sql insert quote in string oracle code example

Example: oracle insert single quote in string

-- Double single quotes:
INSERT INTO my_table (val1) VALUES ('xxx''test''yy'); -- Inserted:  xxx'test'yy