Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: before insert or update trigger that inserts all upper case
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