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 -- -- --
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
What is difference between my sql and sql?
What are string functions in sql?
what does the t-sql command ident_current does? : Transact sql
How can I tell if sql is running?
How do I tune a sql query?
What schema means?
What is a clob in sql?
What is an index in sql with example?
Is inner join same as self join?
What is clause in sql?
What is difference between cursor and trigger?
describe transaction-safe table types in mysql : sql dba
Does asenumerable execute the query?
What operating systems are supported by oracle sql developer?
What is tuple in sql?