How to make unique constrant on a column case-INsensitive in Oracle 9
From: Genna <gralko_at_gmail.com>
Date: 14 Oct 2005 14:08:31 -0700
Message-ID: <1129324111.358555.207850_at_g44g2000cwa.googlegroups.com>
I have a task:
[Quoted] set unique constraint on a table column but I don't care about case sensitivity. How to implement it? I know Oracle 10 has NLS_SORT=xxxx_CI setting with 'CI' suffix that is 'Case Insensitive' just to address the issue. But I need to solve this for Oracle 9. Thanks in advance.
Genna. Received on Fri Oct 14 2005 - 23:08:31 CEST
Date: 14 Oct 2005 14:08:31 -0700
Message-ID: <1129324111.358555.207850_at_g44g2000cwa.googlegroups.com>
I have a task:
[Quoted] set unique constraint on a table column but I don't care about case sensitivity. How to implement it? I know Oracle 10 has NLS_SORT=xxxx_CI setting with 'CI' suffix that is 'Case Insensitive' just to address the issue. But I need to solve this for Oracle 9. Thanks in advance.
Genna. Received on Fri Oct 14 2005 - 23:08:31 CEST