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
7720 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 select everything, but 1 or 2 fields, without writer's cramp?

930

Which join is like inner join?

973

column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.

7130

Is stored procedure faster than query?

913

What is time based sql injection?

900

how is myisam table stored? : Sql dba

995

What is a clob in sql?

965

In what condition is it good to disable a trigger?

967

What are sql functions? Describe the different types of sql functions?

1054

How can I get the number of records affected by a stored procedure?

999

Why do we need cursors in pl sql?

1000

What is string join?

931

What is cost in sql execution plan?

897

Differentiate between % rowtype and type record.

1192

How can you know that statistics should be updated?

1025