Re: Trigger to force fields to lowercase at insert/update

On Wed, Apr 26, 2006 at 12:52:55 -0700,
Leonardo Boiko <leoboiko(at)gmail(dot)com> wrote:
> Suppose I have a bunch of fields in different tables which I'd like to
> always force to lowercase (since they represent case-insensitive data).
> Suppose I want to do it at SQL level, not application level. If the
> user say "INSERT INTO foo VALUES ('Abc')", I want to really insert
> 'abc'. Is there an elegant way of doing this? Some kind of trigger,
> maybe? I have no experience with triggers or pl/sql, but I couldn't
> come up with a solution general enough to be reused in multiple places.
> Or is the premise a bad idea?

You can use a before trigger to change the value of the column when it
is inserted or updated.