Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Force Upper Case
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/servicesReceived on Fri Oct 05 2007 - 14:49:53 CDT
![]() |
![]() |