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