Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7995 Views
- I also Faced
- E-Mail Answers
Answer Posted / kalyan
update test set NAME=regexp_replace(NAME,'( ){2,}', ' ')
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Which version of sql do I have?
How do you concatenate in sql?
How do you optimize a stored procedure query?
What is a data manipulation language?
What is the difference among union, minus and intersect?
What is hibernate and its relation to sql?
What sql does db2 use?
Why do we need cursors in pl sql?
Explain ttitle and btitle.
Why do you partition data?
What is difference between left and right outer join?
What does the argument [or replace] do?
why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba
Can we have two clustered index on a table?
How to check if a column is nullable before setting to nullable?
