update test set NAME=regexp_replace(NAME,'( ){2,}', ' '

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 -- -- --

Question Posted / kalyan

5 Answers
7890 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

Please Help Members By Posting Answers For Below Questions

Is mariadb nosql?

1029

How bulk collect improves performance?

985

what is the difference between a having clause and a where clause? : Sql dba

1062

Is sql a backend?

1003

Can I copy :old and :new pseudo-records in/to an oracle stored procedure?

1195

what is subquery? : Sql dba

1111

Can a foreign key have a different name?

933

How do I save a sql query?

1001

How would you reference column values before and after you have inserted and deleted triggers?

1049

Is sql procedural language?

953

Can we use rowid as primary key?

966

What is a function in oracle pl sql?

1014

What is the difference between left and left outer join?

938

What is the use of nvl function?

1175

Why we use pl sql?

942