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

From: Genna <gralko_at_gmail.com>
Date: 24 Oct 2005 07:45:37 -0700
Message-ID: <1130165137.771710.251570_at_f14g2000cwb.googlegroups.com>

[Quoted] 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). Received on Mon Oct 24 2005 - 16:45:37 CEST

This message: [ Message body ]
Next message: DA Morgan: "Re: FRM-40405 : No changes to apply error."
Previous message: gareth_at_jamms.org: "Re: Need advice.."
In reply to: IANAL_VISTA: "Re: How to make unique constrant on a column case-INsensitive in Oracle 9"
Next in thread: DA Morgan: "Re: Database startup verification for Windows Services?"
Reply: Sybrand Bakker: "Re: How to make unique constrant on a column case-INsensitive in Oracle 9"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message