Oracle9i does not contain a native way to make data case insensitive. Your only recourse at this point is to use a trigger to modify the incoming data. Or you could store the data in mixed case and then create a Function Based Index to help you search for the data in all upper, or lower case.
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.