How to get the substring value from a column with data?

[rshivagami]

select substr(names,1,1) || substr(names, instr(names,' ')+1,1) from tablename;

You might want to add a decode before the second concatenation to check if there is a space.