Thanks to Kavitha and Lince. Both answers are correct in oracle and in Sql

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 / manojkumar

5 Answers
7789 Views
I also Faced
E-Mail Answers

Answer Posted / manojkumar

Thanks to Kavitha and Lince.
Both answers are correct in oracle and in Sql Server.
Excellent
Thanks a lot

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain unique key in sql.

958

How do I view an execution plan in sql?

931

What is %type in sql?

927

Is json a nosql?

930

What is output spooling in sql*plus?

998

Why do we use function in pl sql?

1028

How do I run a program in pl sql?

970

What is primary key and unique key?

1071

What is compute?

1028

How many types of functions are there in sql?

911

How much ram can sql express use?

947

What is a .db file?

944

what is dbms? : Sql dba

944

Which normal form is best?

909

How can a function retun more than one value in oracle with proper example?

1041