Re: Constraint Implementation Question

From: Michael Leung <wmleung_at_hk.super.net>
Date: Thu, 10 Dec 1998 22:26:33 +0800
Message-ID: <366FDA19.1BB0D79F@hk.super.net>

As far as I know, it cannot be implemented decoratively and you may need a trigger to do it. However, if you just concern the column has upper case value only, you may use column constraint to ensure only upper case values are inserted into the column.

e.g. set a constraint to check the value of a column = its upper value (columnA = upper(columnA))

regards,
Michael Leung

dan.hield_at_mcmail.com wrote:

> I have an Oracle7 database on which I wish to enforce a table column to only
> contain upper case text. Can anyone tell me if this can be implemented
> declaratively or must it be done with the use of a trigger? Which ever the
> case, can you offer any suggestions that would help me do such a thing?
>
> Many thanks!
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Thu Dec 10 1998 - 08:26:33 CST