Trim Sql Not Getting It

thanks in advance

MY SQL QUERY OUTPUT SHOWS LIKE THIS

NAME
---------
GAJANAN KINI
PRASHANT KINI
AJAY KINI

i want the output to be like this

NAME
--------------
GAJANANKINI
PRASHANTKINI
AJAYKINI

i tried but not getting this output. can someone advise me

So, what is the query that you are trying to run?

you could try

select replace (name,'') from table;

SQL> select replace('abcd xyz',' ','') from dual ;

REPLACE
-------
abcdxyz


Tamil