Re: 9i: Check- constraint Upper(Column)

Carlos schrieb am 02.04.2008 in
<221a3638-5b82-4086-b097-8e06e50bdccf_at_x41g2000hsb.googlegroups.com>:

> Not sure about what you're trying to do, but a Function Based Unique
> Index on (trim(upper(column))) may do the trick...
I try to ensure, that it is impossible to insert/update records in the way, that after this there are two records, that differ only by BIG/little - Letters and the number of spaces

example:

CMyColumn

It should be impossible to insert a record with CMyColumn = 'TEST ENTRY' or 'test entry' or ' test entry ' ...

> HTH.

I tried it out:
CREATE UNIQUE INDEX MySchema.MyIndexName

    ON MySchema.MyTable upper(trim((CLOGINNAME)))     TABLESPACE MyIndexTableSpace LOGGING; No Problem to create that index, but, after it, still no problem to insert f.e. 'TEST ENTRY'

Any more idea?

> Cheers.

Thanks
> Carlos.

Andreas

-- 
wenn email, dann AndreasMosmann <bei> web <punkt> de