Reputation: 3219
How to escape double quote character in Oracle identifier?
This doesn't work:
CREATE TABLE "foo""bar" ("xxx" CHAR(1))
Upvotes: 1
Views: 3327
Reputation: 262814
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