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
8157 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 column in a table?

1187

What is the use of procedures?

1016

How do I remove duplicates in two columns?

1149

What is the current version of sql?

1069

Why indexing is needed?

1045

What is full join in sql?

1035

How do you exit in sql?

1159

What are operators available in sql?

1095

Why do we need cursors in pl sql?

1157

How to execute a stored procedure?

1158

How do you get column names only for a table (sql server)?

1217

What is thread join () in threading?

1057

explain normalization concept? : Sql dba

1090

How to handle bulk data?

1367

Can we use join in subquery?

1150