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

How is a process of pl/sql compiled?

1160

What are the different types of tables in sql?

1009

Can we use update in sql function?

1060

What is dense_rank?

935

How many tables can a sql database have?

977

How exception is different from error?

1017

What is the current version of sql?

1023

When should I use nosql database?

1006

What are the different ways to optimize a sql query?

946

how to include character strings in sql statements? : Sql dba

1071

What is difference between db2 and sql?

999

Explain the steps needed to create the scheduled job?

1038

How do I copy a table in sql?

988

What type of database is sql?

1023

How do I run a program in pl sql?

1002