Re: Force input data to upercase?

In article <4ania6$i29_at_newsbf02.news.aol.com>,

   bdreher_at_aol.com (BDreher) wrote:
>I'm looking for a method to force a users inserts to a table to
>switch lowercase text to uppercase.

Create a BEFORE INSERT trigger for the table. Within this trigger, use the UPPER function to uppercase the new value, like this...

        :new.column_name := UPPER(:new.column_name);

       :
      /^\
     :   :
     :___:
___.^:_._:^._______________________________________________________________
   :-:.^.:-:                        :
   :_:|=|:_:  Robert Goodwin        :  phone:  (205)461-4582
   : :|.|: :  Database Development  :  fax:    (205)461-4999
   :-/|.|\-:  New Technology, Inc.  :
   :/ |.| \:  Huntsville, AL        :
 (__|.|__)                        :
   :_:(|):_:  NASA/MSFC             :  e-mail: robert.goodwin_at_msfc.nasa.gov
 --/^\^|^/^\---------------------------------------------------------------
   /\\   //\