put the table in upper case
- From: raja rao <raja4list@xxxxxxxxx>
- To: oracle list <oracle-l@xxxxxxxxxxxxx>
- Date: Sat, 5 Nov 2005 16:17:08 -0800 (PST)
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.
Other related posts:
