CODEWITHSUNDEEP
oracle11g
tale852150
tale852150

Reputation: 1628

Oracle 11gR1 - case insenstive columns

Oracle 11gR1

Is there a way to set an Oracle instance to treat all columns as uppercase i.e. make the Oracle instance case-insensitive when accessing a database that has case-sensitive column names?

Upvotes: 0

Views: 46

Answers (1)

Justin Cave
Justin Cave

Reputation: 231751

Oracle is, by default, case-insensitive. You'd only have case-sensitive identifiers if the original developer intentionally created them that way. If that's what was done, you'd have no choice but to use case-sensitive names when interacting with the database (one of the reasons that case-sensitive identifiers are discouraged).

You could, of course, write a bit of dynamic SQL that would alter any table or column names that were created in a case-sensitive manner to be case-insensitive. But that would likely break any code that is currently written that assumes that the identifiers are case-sensitive.

Upvotes: 1

Related Questions