select substr(name,1,instr(name,' ',1)-1)||substr(name,instr(name

Like shown below i have 3 columns(Name,No,Address). The
values in name column i want to modity.
Requirement : Keep only once space between two words
(Fname,Lname) in the Name column.
For this what is the query? Please answer me. Advance
Thanks.

Name No Address Reference

manoj kumar
kumar raja
vinzay kumar
rajendra prasad
gowri nath -- -- --

Question Posted / swastik

5 Answers
7891 Views
I also Faced
E-Mail Answers

Answer Posted / swastik

select substr(name,1,instr(name,' ',1)-1)||substr(name,instr(name,' ',-1),length(name)) from spacename

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Does group by remove duplicates?

1021

How can we avoid duplicating records in a query?

958

What happens when a trigger is associated to a view?

896

What is %type in sql?

948

Why do we need sharding?

978

What is sql profiler in oracle?

1070

What is identity column in sql server?

1035

What is the need of merge statement?

1012

What are the basic sql commands?

1071

How to run sql functions in pl/sql?

1041

What is sql comments?

1060

How to use distinct and count in sql query? Explain

1000

What is the difference between sum and count in sql?

973

How do you update f as m and m as f from the below table testtable?

1834

Can delete statement be rollbacked?

968