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

Write a query to find the names of users that begin with "um" in sql?

993

How do you declare a variable in pl sql?

1019

Why stored procedures are faster than query?

1021

What is the difference between inner join and left join?

984

Can we use threading in pl/sql?

1036

Explain the difference between 'between' & 'and' operators in sql

996

Is pl sql useful?

987

Does truncate require commit?

967

Why join is faster than subquery?

1107

Whis is not false in primary key?

1452

What is the difference between a primary key and a unique key?

1052

What are all types of user defined functions?

1073

Which is faster joins or subqueries?

986

Can you have a foreign key without a primary key?

951

Does sql backup shrink transaction log?

977