ORACLE: Remove Whitespaces from a string

To remove whitespaces from a string use a regex:

REGEXP_REPLACE(text,'(^[[:space:]]*|[[:space:]]*$)')

Source:
https://stackoverflow.com/