Re: How to make unique constrant on a column case-INsensitive in Oracle 9
From: Sybrand Bakker <gooiditweg_at_nospam.demon.nl>
Date: Sat, 29 Oct 2005 12:03:52 +0200
Message-ID: <26i6m11mpb3jt48jsnqplal0rjkqffqord_at_4ax.com>
Date: Sat, 29 Oct 2005 12:03:52 +0200
Message-ID: <26i6m11mpb3jt48jsnqplal0rjkqffqord_at_4ax.com>
On 24 Oct 2005 07:45:37 -0700, "Genna" <gralko_at_gmail.com> 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 DBAReceived on Sat Oct 29 2005 - 12:03:52 CEST