Surprising SQL

In Oracle SQL statements it is not allowed to use reserved words as identifiers. For example, it would confuse the SQL parser – and us as well – to name a table as TABLE or a column as SELECT. Of course, it is possible to use such names when the name is written in double quotes, but a statement like CREATE TABLE “TABLE” is definitely not a good practice.

Continue reading