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

How do I find sql profiler?

885

What is the use of function "module procedure" in pl/sql?

1134

Write a sql query to find the names of employees that begin with ‘a’?

951

Is left join same as join?

937

What is auto increment in sql?

1061

What is where clause in sql?

982

What is substitution variable in pl sql?

979

What type of join is sql join?

922

Which is faster count (*) or count 1?

964

What is the difference between syntax error and runtime error?

1065

What operators deal with null?

1029

what are all the common sql function? : Sql dba

1010

What is indexing oracle sql?

1025

What is oracle and pl sql?

1080

How many types of relationship are there?

974