Re: 9i: Check- constraint Upper(Column)
Date: Wed, 2 Apr 2008 06:24:35 -0700 (PDT)
On 2 abr, 11:19, Andreas Mosmann <mosm..._at_expires-30-04-2008.news- group.org> wrote:
> Hi newsgroup,
> Is it possible to build a constraint, that ensures, that there are not
> more entries in a column, that look like
> 'Abc ' -> trim(upper(..))='ABC'
> 'ABC' -> trim(upper(..))='ABC'
> 'aBC ' -> trim(upper(..))='ABC'
> Alternativ I could build a shadow column filled by a trigger that
> containes trim(upper(..)) and a check constraint on this, but it seems
> to me that there is a better way.
> Thank you in advance
> Andreas Mosmann
> wenn email, dann AndreasMosmann <bei> web <punkt> de
Not sure about what you're trying to do, but a Function Based Unique Index on (trim(upper(column))) may do the trick...
Carlos. Received on Wed Apr 02 2008 - 08:24:35 CDT