Re: Unique key with capatilizing

From: victor <victor_at_PERCOMBANK.KIEV.UA>
Date: 13 Nov 1998 11:30:26 GMT
Message-ID: <01be0ef8$f3139e20$6b14abcc@victor>

Nicolas Bronke <NBronke_at_t-online.de> wrote in article <72f34q$f5a$1_at_news00.btx.dtag.de>...
> Is it possible to create an unique index on a varchar2-column which
handles
> uppercases like lowercase?
>
> Example:
>
> It should not be possible to insert in that Column a value like Oracle,
> ORACLE, oracle.
> Only one of them shall be allowed (it does no matter which)
>
> Regards
> Nicolas Bronke
>
>
>

you can use triger
create or replace trigger zzz before insert on zzztbl for each raw
begin
:new.collname:=upper(:new.collname)
end;

and you can insert any cases of OrAcLe but in table will be only ORACLE Received on Fri Nov 13 1998 - 05:30:26 CST