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
7997 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

Can you join a table to itself?

1144

What is a primary key called that is made up of more than one field?

1356

What are the different types of dbmss?

1018

How do I trace sql profiler?

995

What are the packages in pl sql?

1023

what are date and time functions in mysql? : Sql dba

986

Explain the types of joins in sql?

1038

What is a temporal data type?

1057

Why is sql important?

1117

How are sql commands classified?

1096

Why is nosql good?

1036

Is it possible to link two groups inside a cross products after the cross products group has been created?

1009

explain the difference between delete , truncate and drop commands? : Sql dba

1101

what is the difference between $message and $$message? : Sql dba

1006

What is sql query optimization?

1125