Re: put the table in upper case

Take a look at this section of the SQL Loader manual. http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14215/ldr_field_list.htm#sthref1238 Tiny Url: *http://tinyurl.com/96xl5

*It shows how to apply SQL operaters to a field.

It used to be that you could not do that on direct imports.

Depending on version, that may have changed.

HTH Jared
*
*
On 11/5/05, raja rao <raja4list_at_yahoo.com> wrote:
>
> 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://us.lrd.yahoo.com/_ylc=X3oDMTFqODRtdXQ4BF9TAzMyOTc1MDIEX3MDOTY2ODgxNjkEcG9zAzEEc2VjA21haWwtZm9vdGVyBHNsawNmYw--/SIG=110oav78o/**http%3a//farechase.yahoo.com/>
>
>

--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l