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
Does sql view stored data?
What is cross join example?
Why we use cross join?
Can we use ddl statements in stored procedure sql server?
How do temporal tables work?
Can a table have no primary key?
What are the different sql languages?
How to make a copy values from one column to another in sql?
Is subquery faster than join?
What is the difference between a database and a relational database?
Write a sql query to get the third highest salary of an employee from employee_table?
Where is pl sql used?
What is insert command in sql?
Show code of a cursor for loop.
What are the advantages of pl sql?