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
8162 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 sql*plus have a pl/sql engine?

1131

What are the different sql languages?

1093

What is a trigger in sql?

1234

Differentiate between pl/sql and sql?

1217

what is a view? : Sql dba

1135

What is write ahead logging in sql server?

1101

What is dbo in sql?

1019

What is the difference between explicit and implicit cursors in oracle?

1115

What is %type in sql?

1020

Can two tables have same primary key?

1024

what is dbms? : Sql dba

1036

how can we know the count/number of elements of an array? : Sql dba

1109

what is bdb (berkeleydb)? : Sql dba

1093

How do I run a pl sql procedure in sql developer?

1022

how to convert character strings to dates? : Sql dba

1101