Home -> Usenet -> comp.databases.oracle -> case-insensitivity in tables

case-insensitivity in tables

From: -yoshida a.w. <awy_at_wisny.mv.att.com>
Date: Thu, 1 Sep 1994 18:15:58 GMT
Message-ID: <CvGqqM.73t_at_nntpa.cb.att.com> 







What is the most efficient way to ensure that a particular table always
has its data inserted/updated in either lower-case or upper-case.  We would
like to avoid having to constantly perform lower(column) = lower(value)
for each comparison made.  Are triggers the best way to accomplish this?
Any thoughts would be appreciated.



    
  
  •   Andre Yoshida



Received on Thu Sep 01 1994 - 20:15:58 CEST












Original text of this message