CODEWITHSUNDEEP
special-charactersoracle9i
Dominating
Dominating

Reputation: 2930

How to escape special words in oracle?

I have the following query:

CREATE TABLE FOR_DELETE([DATE] DATE )

but it seems that there is a difference in escaping special words as INT, DATE and so on and its not like in SQL... How to escape special word?

Upvotes: 1

Views: 289

Answers (1)

Romain
Romain

Reputation: 12839

Standard SQL would use double-quotes ("), and some implementations may use backticks (`). Out of the top of my head, Oracle will take the double-quotes.

Upvotes: 1

Related Questions