Anuj kumar singh Oracle DBA

Remove space between Number/string string




SQL> select TRANSLATE('12123 3434 4535 5656','0123456789 ','0123456789') from dual ;

TRANSLATE('121233
-----------------
12123343445355656

1 row selected.



SQL> select replace('I am vihaan','vihaan','anuj') from dual;


REPLACE('
---------
I am anuj

1 row selected.


To remove space


SQL> select replace('I am vihaan ',' vihaan','anuj') from dual;


REPLACE('
---------
I amanuj

1 row selected.