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 / kalyan
update test set NAME=regexp_replace(NAME,'( ){2,}', ' ')
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
what is row? : Sql dba
What is out parameter used for eventhough return statement can also be used in pl/sql?
How many indexes can be created on a table in sql?
What is the difference between pl and sql?
How to write pl sql program in mysql command prompt?
How many sql statements are used?
what is the difference between truncate and drop statements? : Sql dba
What is clause?
What is sqlite format?
Explain architecture of sql server notification services?
explain the difference between bool, tinyint and bit. : Sql dba
What are sql injection vulnerabilities?
What do you mean by stored procedures?
what is the difference between a web-garden and a web-farm? : Sql dba
What is a unique key?