Use a before insert trigger, and use the upper function on all columns in
this one procedure?
--
Syltrem
OpenVMS 7.3-1 + Oracle 9.2.0.5
http://pages.infinit.net/syltrem (OpenVMS related web site, en français)
---zulu is not in my email address---
"Rob Williamson" <robw_at_physics.umd.edu> a écrit dans le message de
news:dajchj$m0h$1_at_grapevine.wam.umd.edu...
> To make sure all enties in one column are Upper Case you can do the
> following
>
> create table test2(
> lname varchar2(10) not null,
> fname varchar2(10),
> constraint test2_lname_ck CHECK ( TO_UPPER(lname)),
> constraint test2_fname_ck CHECK ( TO_UPPER(fname))
> );
>
>
> Is there away to just have one table level constraint that makes all
> columns in the whole table all upper case without having to write
> constraints for each column?
>
Received on Thu Jul 07 2005 - 09:09:17 CDT
