Force identifier case sensitivity in oracle

Question

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"

If you create the tables with table names in qoutes it should work as you like it. — eisberg, Nov 12 '12 at 15:20
I believe the quoted identifers are the way to stop the behaviour, not aware of a global setting to change it. — Andrew, Nov 12 '12 at 15:21
@eisberg, the table is already created with lower case characters. — linepogl, Nov 12 '12 at 15:26
@linepogl Reading your question again. And if your goal is to change the silent behavior of Oracle and stop it from silently capitalizing the answer is just *no*. — eisberg, Nov 12 '12 at 15:29

score 1 · Accepted Answer · edited Jun 20 '20 at 09:12

1

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).

edited Jun 20 '20 at 09:12

Community

1
1

answered Nov 12 '12 at 15:37

Vincent Malgrat

66,725
9
119
171

Force identifier case sensitivity in oracle

1 Answers1

Linked