function to delete extra spaces between words - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: function to delete extra spaces between words

  1. #11
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    Why would you want to? If you need to update values, just call the function:
    Code:
    update test
      set remarks = remove_redundant_spaces (remarks);
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  2. #12
    Join Date
    Aug 2001
    Posts
    111
    I would be interested on the performance of this function,
    my gut feeling is it will be a shocker... even if you create a function based index (with the right version)

    We had a developer use a Java function within Oracle(8i) to do something similar ... comparing strings and saw a dramatic improvement over PL/SQL method.

    I would be inclined to make sure to fix the input checking before it gets into the database. Or if you need to do a large cleanup: dump the table to text, use perl and reload the table, especially if the table is very,very big.

    The reality is that some things were not meant to run in a database. And when it comes the text manipulation PERL kicks arse.

    Have Fun
    Performance... Push the envelope!

  3. #13
    Join Date
    Jun 2000
    Location
    dumfries,va,usa
    Posts
    227
    Thanks, the function works well. The table is not a big about 2k rows.

    leonard905
    leonard905@yahoo.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width