Identify blank spaces in a string

[knowledgebalaji]

Hi,

kindly try this query

select Replace(' Hi what is ur name' ,' ') from dual;