SELECT regexp_replace('A...B..C.D......E....F', '[.]+',

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 / sreenivasulu sangatipalli

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

Answer Posted / sreenivasulu sangatipalli

SELECT regexp_replace('A...B..C.D......E....F', '[.]+', '.') FROM DUAL;

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what are date and time data types in mysql? : Sql dba

1024

What are two statement types in sql?

1160

What is the difference between delete and truncate statement in sql?

1130

what is the bond code in materialized view?

3062

What is relationship? How many types of relationship are there?

1264

what are all the different types of indexes? : Sql dba

1107

Can I join the same table twice?

1095

How do I turn a list into a table?

1012

What are expressions?

1062

How to start the command-line sql*plus?

1111

What is the primary use of normalization?

1053

What are crud methods?

1086

what are properties of a transaction? : Sql dba

1138

What can sql server reporting services do?

1164

what is a foreign key ? : Sql dba

1116