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
>
select the column names in user_tab_columns and generate an "update ...
set xxx=upper(xxx)" for each of them (e.g. by spooling sqlplus output to
go.sql and running go.sql afterward.)
Received on Fri Oct 05 2007 - 13:14:32 CDT
