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
10499 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 is substitution variable?

1052

What is flag in sql?

1035

What is java sql drivermanager?

1099

Explain the savepoint statement.

1099

What does closing a cursor do?

1322

how does a local variable is defined using t-sql? : Transact sql

1018

Why is stored procedure faster than query?

960

Which is better varchar or nvarchar?

997

how to fetch common records from two tables? : Sql dba

1172

Explain how exception handling is done in advance pl/sql?

999

What is sharding in sql?

987

what is text? : Sql dba

1072

hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews

2016

What is sql comments?

1075

What are the benefits of triggers?

1172