Re: put the table in upper case
- From: "Radoulov, Dimitre" <cichomitiko@xxxxxxxxx>
- To: "Khemmanivanh, Somckit" <somckit.khemmanivanh@xxxxxxxxxxxxxxxx>
- Date: Mon, 7 Nov 2005 22:28:38 +0100
Yep,
< > is more efficient.
Regards,
Dimitre Radoulov
----- Original Message -----
From: Khemmanivanh, Somckit
To: cichomitiko@xxxxxxxxx ; raja4list@xxxxxxxxx
Cc: oracle list
Sent: Monday, November 07, 2005 9:04 PM
Subject: RE: put the table in upper case
Reminds me of the useless use of cat awards by Randal Schwartz, was it?
cat test.txt | tr "[:lower:]" "[:upper:]" > TEST.txt
Can be -- tr "[:lower:]" "[:upper:]" < test.txt > TEST.txt
------------------------------------------------------------------------------
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Radoulov, Dimitre
Sent: Sunday, November 06, 2005 2:01 AM
To: raja4list@xxxxxxxxx
Cc: oracle list
Subject: Re: put the table in upper case
You can use this command on Unix to translate all lower-case characters to
upper-case and then use sqlloader in direct mode :)
$ cat test.txt
TesT
TEST
tEst
test
$ cat test.txt | tr "[:lower:]" "[:upper:]" > TEST.txt
$ cat TEST.txt
TEST
TEST
TEST
TEST
HTH,
Dimitre Radoulov
----- Original Message -----
From: Jared Still
To: raja4list@xxxxxxxxx
Cc: oracle list
Sent: Sunday, November 06, 2005 3:04 AM
Subject: 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@xxxxxxxxx> 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.
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Other related posts:
