insert string which includes quotes in oracle

Question

How can I insert string which includes quotes in oracle? my code is

INSERT INTO TIZ_VADF_TL_MODELS (name)
VALUES ('xxx'test'yy');

if I use

INSERT INTO TIZ_VADF_TL_MODELS (name)
VALUES ("xxx'test'yy");

I get identifier is too long error because xxx'test'yy is clob.

how can I do that?

thx.

Answer 1

Try escaping the quotes:

'xxx''test''yy'

In SQL quotes can be escaped by adding another quote before them.