Re: put the table in upper case

User upper function in the sqlloader control file. If you are 9i or higher you can use direct load.

Sandeep

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://www.freelists.org/webpage/oracle-l