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

Can we use commit inside a trigger?

1147

What language is oracle sql developer?

1071

What is pl sql collection?

1017

what are the t string functions available in tsql? : Transact sql

1065

How many types of privileges are available in sql?

1404

what is the difference between truncate and delete statement? : Transact sql

1122

what are ddl statements in mysql? : Sql dba

1269

What is a pragma statement?

1336

What is the sql query to display the current date?

1094

Is trigger a stored procedure?

984

What can sql server reporting services do?

1165

Why use subqueries instead of joins?

1138

Is time a data type in sql?

964

Can a primary key be a foreign key?

1081

how many tables will create when we create table, what are they? : Sql dba

1119