TO_UPPER on entire table?

From: Rob Williamson <robw_at_physics.umd.edu>
Date: Thu, 07 Jul 2005 10:00:22 -0400
Message-ID: <dajchj$m0h$1@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:00:22 CDT