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

What is multiple partition?

962

What does cursor do in sql?

1014

What is an exception in pl/sql?

1079

Why is sharding used?

993

Define join and name different types of joins?

1004

What is lookup table in sql?

1037

Enlist the characteristics of pl/sql?

1795

What is file based approach?

936

What is sqlexception in java?

981

How to get list of all tables from a database?

1151

How to pipe multiline string to isql?

1003

How do you concatenate in sql?

1025

how to create a test table in your mysql server? : Sql dba

1002

Can we commit inside a trigger?

987

what are the t string functions available in tsql? : Transact sql

1002