SELECT REGEXP_REPLACE ( REPLACE ('A.B....C.......D.........E.....

Suppose There is a string
A.B....C.......D.........E........F In this string dots (.)
are not having fixed count in between of string. I want the
output to have string with one dot between. I.e.
A.B.C.D.E.F

Question Posted / anuradha

6 Answers
10227 Views
IBM, I also Faced
E-Mail Answers

Answer Posted / anuradha

SELECT REGEXP_REPLACE (
REPLACE ('A.B....C.......D.........E........F', '.', ' '),
'( ){2,}',
'.')
FROM DUAL;

Is This Answer Correct ?

3 Yes

5 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is union and union all keyword in sql?

968

What are different types of queries in sql?

1044

What does <> sql mean?

985

What is not null in sql?

981

What are records give examples?

953

What are the different sql commands?

1000

what is the difference between cluster and non cluster index? : Sql dba

954

Why procedure is used in sql?

968

how to check server status with 'mysqladmin'? : Sql dba

1010

What does a pl/sql package consist of?

928

how to show all tables with 'mysql'? : Sql dba

1058

Describe sql comments?

959

Can we create clustered index without primary key?

898

Explain table and field in sql?

1013

Explain the steps needed to create the scheduled job?

965