Re: 9i: Check- constraint Upper(Column)
From: Andreas Mosmann <mosmann_at_expires-30-04-2008.news-group.org>
Date: Wed, 02 Apr 2008 16:57:57 +0200
Message-ID: <1207148277.16@user.newsoffice.de>
Date: Wed, 02 Apr 2008 16:57:57 +0200
Message-ID: <1207148277.16@user.newsoffice.de>
fitzjarrell_at_cox.net schrieb am 02.04.2008 in
<7494e42c-9b44-4cc4-a6c4-fbfbe33e7a84_at_8g2000hsu.googlegroups.com>:
> A check constraint can be written using the upper() function. I've
> done that before and it works without issue.
Can you give me the syntax for this? I did not understand the text in the reference completely ...
ALTER TABLE TMyTable ADD CONSTRAINT MyConstraintName CHECK (_condition_);
what to write as _condition_?
> David Fitzjarrell
Thank you
Andreas Mosmann
-- wenn email, dann AndreasMosmann <bei> web <punkt> deReceived on Wed Apr 02 2008 - 09:57:57 CDT