Re: Case sensitive

daniellopez21 wrote:

> I have problem with "case sentitive" in Oracle.

Oracle is not case sensitive. Do not confuse case sensitivity of the database engine, with that of the data you store in it.

I.e. I can code [SELECT FOO_COL FROM FOO] or [select foo_col from foo] and Oracle will not have a problem with case.

Whether the data inside FOO_COL is uppercase, lowercase, mixedcase, high Hungarian or Zulu.. Oracle does not care. It is your data and your problem and your solution.

> When I use the UPPER function, sql statment not acces by index.

Obviously as the index on the COLUMN and not on UPPER(COLUMN).

> How I can disable de "case sensitive" of oracle

Wrong question. Wrong perception.

You need to decide whether or not the data is case sensitive. Is it? If not, then why do you store it as case sensitive? If it is and searching on this column needs to be case insensitive, create a function-based index UPPER(COLUMN) to addess that.

And please read the Oracle Concepts and Oracle Application Developer Fundementals. It is *critical* to understand Oracle in order to use it correctly.

--
Billy