Re: How to make unique constrant on a column case-INsensitive in Oracle 9

On 24 Oct 2005 07:45:37 -0700, "Genna" <gralko@xxxxxxxxx> wrote:

>thx for your comment. it's actually the way I have it implemented right
>now. added this UPPER() check in a table trigger and made it fire a
>custom error. Does anybody know a nicer and more efficient way to do
>this case-INsensitive unique constraint on a table column (not the
>whole table or database).

An ordinary check constraint would do. CHECK (column = UPPER(column))

--
Sybrand Bakker, Senior Oracle DBA
.

Relevant Pages