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