Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!east1.newsfeed.sprint-canada.net!tor-nx1.netcom.ca!tor-nn1.netcom.ca.POSTED!not-for-mail
From: "Syltrem" <syltremzulu@videotron.ca>
Newsgroups: comp.databases.oracle.server
References: <dajchj$m0h$1@grapevine.wam.umd.edu>
Subject: Re: TO_UPPER on entire table?
Lines: 28
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
Message-ID: <IIaze.159$rO4.807@tor-nn1.netcom.ca>
Date: Thu, 7 Jul 2005 10:09:17 -0400
NNTP-Posting-Host: 216.191.6.50
X-Complaints-To: abuse@allstream.net
X-Trace: tor-nn1.netcom.ca 1120745384 216.191.6.50 (Thu, 07 Jul 2005 10:09:44 EDT)
NNTP-Posting-Date: Thu, 07 Jul 2005 10:09:44 EDT
Organization: Allstream
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:246775

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@physics.umd.edu> a écrit dans le message de
news: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?
>