RE: put the table in upper case

From: Khemmanivanh, Somckit <somckit.khemmanivanh_at_weyerhaeuser.com>
Date: Mon, 7 Nov 2005 12:04:08 -0800
Message-ID: <65C0D8935651CB4D96E97CEFAC5A12B9010EAFF5@wafedixm10.corp.weyer.pri>

 

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Radoulov, Dimitre Sent: Sunday, November 06, 2005 2:01 AM
To: raja4list_at_yahoo.com
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 <mailto:jkstill_at_gmail.com> To: raja4list_at_yahoo.com Cc: oracle list <mailto:oracle-l_at_freelists.org> 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_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=X3oDMTFqODRtdXQ4BF9TAzMyOTc1MDIEX3MDOTY2OD gxNjkEcG9zAzEEc2VjA21haWwtZm9vdGVyBHNsawNmYw--/SIG=110oav78o/**http%3a// farechase.yahoo.com/>                 

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

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

Received on Mon Nov 07 2005 - 14:06:18 CST