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
7989 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 a system versioned table?

997

Differentiate between syntax and runtime errors.

1195

How do I count records in sql?

1016

How to find 3rd highest salary of an employee from the employee table in sql?

1083

What is sqlite used for?

1008

Which is faster view or stored procedure?

947

how to get a list of all tables in a database? : Sql dba

979

Can we join more than 2 tables in sql?

1027

Write the command to remove all players named sachin from the players table.

1184

What is a recursive join sql?

1077

What is user defined functions?

990

How do you delete duplicates in sql query using rowid?

950

What is mutating error?

972

Explain clause in sql?

1034

How do I run a sql trace?

963