Martin Ždila
Martin Ždila

Reputation: 3219

How to escape double quote character in Oracle identifier?

How to escape double quote character in Oracle identifier?

This doesn't work:

CREATE TABLE "foo""bar" ("xxx" CHAR(1))

Upvotes: 1

Views: 3327

Answers (1)

Thilo
Thilo

Reputation: 262814

It is not possible:

Quoted identifiers can contain any characters and punctuations marks as well as spaces. However, neither quoted nor nonquoted identifiers can contain double quotation marks or the null character (\0).

Upvotes: 5

Related Questions