Urgent: Case sensitive data in PL/SQL

From: ruediger magnet <magnet.ruediger_at_magnet.at>
Date: Sun, 30 Aug 1998 17:11:24 +0200
Message-ID: <6sbqvl$clc$1@orudios.magnet.at>

> Hi ALL!>> I have the problem with CASE SENSITIVE data-queries. For
example,
> when i give my request:
> SELECT * FROM table_name WHERE column1 LIKE 'value1'>
> This request gives results different from the ones given by the request:>
> SELECT * FROM table_name WHERE column1 LIKE 'Value1'>
> The well-known solution to solve CASE SENSITIVE is to use UPPER:
> SELECT * FROM table_name WHERE UPPER(column1) LIKE UPPER('value1')>

> But i would like to know how to configure ORACLE so that we don't need
> to user> the operator UPPER in requests.>> Thank for help.>> -------
> Rudolf Fuhlroth
Received on Sun Aug 30 1998 - 10:11:24 CDT