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

what is the difference between char and varchar data types? : Sql dba

1168

Can we join 3 tables in sql?

1104

How do I create an index in word?

1072

What does count (*) do in sql?

1050

What is the difference between the implicit and explicit cursors?

1106

Is t sql a programming language?

1109

what are the types of join and explain each? : Sql dba

1084

Which type of cursor is used to execute the dml statement?

993

Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

1268

What are secondary keys?

1029

How many clustered indexes can be created on a table?

1122

Does mysql support pl sql?

1225

How to display the current date in sql?

1127

How to check if a column is nullable before setting to nullable?

1176

What is use of term?

1124