Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2005
    Posts
    24

    Unanswered: replace more blanks to one blank

    Hi!

    I try to use an existing Oracle SQL Function to reduce more blanks in a pattern to only one:
    example:
    "Testing example" should replaced with an function to:
    "Testing example"

    Please help,
    thanks,
    Klaus

  2. #2
    Join Date
    Nov 2003
    Posts
    2,934
    Provided Answers: 12
    See the last example for the regexp_replace function in the Oracle manual.

    http://download-uk.oracle.com/docs/c...0.htm#i1305521
    (Bottom of that page)

  3. #3
    Join Date
    Sep 2005
    Posts
    24
    i use an older version, and therefore it is not possible to use regex

  4. #4
    Join Date
    Nov 2003
    Posts
    2,934
    Provided Answers: 12
    Then you should have mentioned your Oracle version in the initial post

Posting Permissions

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