Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Force Upper Case

Re: Force Upper Case

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Fri, 05 Oct 2007 20:49:53 +0100
Message-ID: <47069561.3090807@dial.pipex.com>


learning_codes_at_hotmail.com wrote:
> Hi,
>
> I have about more than 175 fields. Some are different (Characters,
> Date, Numeric, etc). I'm trying to force all capital letter only on
> Character Types at once. I hate to type each of the fields.
>
> Ucase([LastName])
>
> How to set for all fields (characters only) ?
>
> Your help would be much appreciated.
> Thanks
>

If you wish to control input into an application (your code looks like access to me) then you will likely need to do two things.

First you *will* need to ensure that the application validates that the data meets the requirements.

Second, and usually forgotten, you will need to declare appropriate constraints in the database.

If you don't do these things you will get dirty data.

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info/services
Received on Fri Oct 05 2007 - 14:49:53 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US