CODEWITHSUNDEEP
sqloracle-database
linepogl
linepogl

Reputation: 9335

Force identifier case sensitivity in oracle

In oracle, when one uses non-quoted identifiers, they are silently capitalized. In other words these two statements are equivalent:

SELECT name FROM my_table
SELECT "NAME" FROM "MY_TABLE"

Is there any way to stop the silent capitalization, so that the following statements become equivalent?

SELECT name FROM my_table
SELECT "name" FROM "my_table"

Upvotes: 1

Views: 540

Answers (1)

Vincent Malgrat
Vincent Malgrat

Reputation: 67722

No, unfortunately you can't customize how Oracle interprets your identifiers:

Note that Oracle interprets the following names the same, so they cannot be used for different objects in the same namespace:

employees
EMPLOYEES
"EMPLOYEES"

It is a convenience (backward compatibility?) that non-quoted identifiers are converted to upper-case (internally all object names are case-sensitive).

Upvotes: 1

Related Questions