function to delete extra spaces between words

[leonard905]

Hi gang,
Does anyone know of any oracle function that I can use to delete extraneous spaces between words in a string. For example, the input string 'this is a test data end here'.



Rtrim and Ltrim will not delete between words!

Thanks,
Leonard905