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

Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?

2333

how to drop an existing view in mysql? : Sql dba

1102

How many sql core licenses do I need?

994

What are the parts of a sql statement?

1139

What are the rules to be applied to nulls whilst doing comparisons?

1365

What is the difference between explicit and implicit cursors in oracle?

1110

What is sqlerrm?

980

What are the different sql languages?

1089

What are the limitations of sql express?

1114

How is data stored on a disk?

1082

What normalization means?

1014

What is procedure and function?

1033

What is string join?

1023

What do you mean by field in sql?

1121

What plvcmt and plvrb does in pl/sql?

1362