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

What is sql procedures and functions?

994

What is a ddl command?

1070

Can we have two clustered index on a table?

1012

Why do we use procedures in sql?

1062

Is sql open source?

956

Can you have a foreign key without a primary key?

939

How do you modify a trigger?

915

Can a commit statement be executed as part of a trigger?

1039

What are the basic techniques of indexing?

1052

When you have to use a default "rollback to" savepoint of plvlog?

1172

Does sql support programming?

1050

How to move files from one directory to another in pl sql?

1173

what is difference between delete and truncate commands? : Sql dba

1109

What is the difference between rollback and rollback to statements?

1051

What is error ora-12154: tns:could not resolve the connect identifier specified?

1058