Re: put the table in upper case

From: Radoulov, Dimitre <cichomitiko_at_gmail.com>
Date: Mon, 7 Nov 2005 22:28:38 +0100
Message-ID: <022c01c5e3e2$391ea1b0$b400a8c0@IBME1D11967173>

Yep,
< > is more efficient.

Regards,
Dimitre Radoulov

Original Message ----- From: Khemmanivanh, Somckit To: cichomitiko_at_gmail.com ; raja4list_at_yahoo.com 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_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 To: raja4list_at_yahoo.com 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_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.

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

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

Received on Mon Nov 07 2005 - 15:30:51 CST