Re: How to make unique constrant on a column case-INsensitive in Oracle 9
From: IANAL_VISTA <IANAL_Vista_at_hotmail.com>
Date: Sat, 15 Oct 2005 02:05:15 GMT
Message-ID: <Xns96EFC232C4B4FSunnySD_at_68.6.19.6>
Date: Sat, 15 Oct 2005 02:05:15 GMT
Message-ID: <Xns96EFC232C4B4FSunnySD_at_68.6.19.6>
"Genna" <gralko_at_gmail.com> wrote in
news:1129324111.358555.207850_at_g44g2000cwa.googlegroups.com:
> I have a task:
> 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.
>
>
Use either UPPER() or LOWER() functions in the WHERE clause Received on Sat Oct 15 2005 - 04:05:15 CEST