If i try the following query it works fine in replacing the spaces between two words i.e.

SELECT REPLACE('Hi All',' ','')
FROM DUAL;

O/P: HiAll

But if i try the same query with translate function i am getting no o/p i.e.

SELECT TRANSLATE('Hi All',' ','')
FROM DUAL;

O/P: No o/p

Again if i try the following query i.e.

SELECT TRANSLATE('Hi All','H ','H')
FROM DUAL;

O/P: HiAll

I am able to get the desired o/p. So please help me understand how the operation differ in above three cases.

Thanks in advance...