Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: before insert or update trigger that inserts all upper case

Re: before insert or update trigger that inserts all upper case

From: DA Morgan <damorgan_at_psoug.org>
Date: Sat, 16 Jul 2005 08:02:32 -0700
Message-ID: <1121526157.100293@yasure>


Rob Williamson wrote:
> Does anyone have a before insert or update trigger already written
> that inserts or updates only upper case charaters into a column of a
> table. I have been seardhing some of my books but can not find one.
> If any one has one they have been using and wouldn't mind sharing that
> would be great.
> Rob

Sybrand's answer is spot on.

But also look at the examples at www.psoug.org click on Morgan's Library
click on Table Triggers

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Sat Jul 16 2005 - 10:02:32 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US