9i: Check- constraint Upper(Column)

From: Andreas Mosmann <mosmann_at_expires-30-04-2008.news-group.org>
Date: Wed, 02 Apr 2008 11:19:10 +0200
Message-ID: <1207127950.29@user.newsoffice.de>

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
Received on Wed Apr 02 2008 - 04:19:10 CDT

Original text of this message