Geek asks and answers

Insert string, which includes quotes in oracle

How to insert a string that includes quotes in oracle? my code

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 the identifier too long because xxx'test'yy is clob.

How can i do this?

THX

+3
source share
3 answers

You can also use the syntax 'alternative citation mechanism :

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

, , [] , ; . , ]' , , , ; ] - .

, , , , , .

SQL Fiddle.

+7

:

'xxx''test''yy'

SQL , .

+7

. :

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

More articles:


All Articles