put the table in upper case

From: raja rao <raja4list_at_yahoo.com>
Date: Sat, 5 Nov 2005 16:17:08 -0800 (PST)
Message-ID: <20051106001708.60288.qmail@web31415.mail.mud.yahoo.com>

Hi Team,  

We recieve data from various sources in lower,upper case.  

We want all the data to be stored in upper case in the table. The whole data will be loaded using sqlloader.  

Is there any way toload all the data in upper case / any method that makes sure that the table data is always in upper case.  

I cannot use the  

update ... set col1=upper(col1), col2=upper(col2) as this would take long time to update the table everytime.  

Thanks in advance,
Raj                 

---

 Yahoo! FareChase - Search multiple travel sites in one click.
--

http://www.freelists.org/webpage/oracle-l Received on Sat Nov 05 2005 - 18:19:07 CST