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
- 6771 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
What port does sql server use?
Explain lock escalation? : Transact sql
What does a pl/sql package consist of?
Define sql delete statement.
How many times can we commit in a loop?
Why do we use sql constraints? Which constraints we can use while creating database in sql?
What are the types of records?
What is a heap in sql?
Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?
What is java sql package?
What is sql*loader and what is it used for? : aql loader
Name the different types of indexes in sql and define them.
What mean sql?
Is sql injection illegal?
What is restrict in sql?
