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
7944 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 join view in sql?

944

Explain clause in sql?

1025

Differentiate between % rowtype and type record.

1290

Why is sql important?

1098

how is exception handling handled in mysql? : Sql dba

1073

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

1201

Is pl sql still used?

971

What action do you have to perform before retrieving data from the next result set of a stored procedure ?

2564

How do you create a db file?

1011

What are different joins used in sql?

1053

How to test for null values?

1043

What are the possible values that can be stored in a boolean data field?

996

What is auto increment feature in sql?

1119

Which is better trigger or stored procedure?

945

describe transaction-safe table types in mysql : sql dba

1001