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
7727 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 happens if null values are involved in expressions? : Sql dba

1000

What does fetching a cursor do?

1019

Define union, minus, union all, intersect ?

949

Can a view be mutating? If yes, then how?

960

Can we debug stored procedure?

956

What is the syntax and use of the coalesce function?

1097

How you improve the performance of sql*loader? : aql loader

955

Explain the select statement in sql?

1043

Is drop table faster than truncate?

940

Does pl/sql support create command?

1044

What is package in pl sql with an examples?

970

What are different categories of sql commands?

1067

How do I tune a sql query?

933

How do sql triggers work?

987

what is dbms? : Sql dba

932