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 -- -- --
- 5 Answers
- 7037 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
What is the difference between count 1 and count (*) in a sql query?
Is pl sql a programming language?
How do you take the union of two tables in sql?
Can a trigger call a stored procedure?
How to raise user-defined exception with custom sqlerrm ?
What are stuff and replace function?
How to run sql statements with oracle sql developer?
How do I count rows in sql?
What is meant by <> in sql?
Explain what is an index?
What is duration in sql profiler trace?
What do you mean by dbms? What are its different types?
Which type of cursor is used to execute the dml statement?
What do you understand by pl/sql cursors?
Is subquery faster than join?
