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 / sunaksha

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

Answer Posted / sunaksha

select REGEXP_REPLACE ('A.B....C.......D.........E........F','.{1,}',
'.') FROM DUAL;

Is This Answer Correct ?

0 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Do prepared statements prevent sql injection?

996

Is it possible to link two groups inside a cross products after the cross products group has been created?

1067

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

1366

Is it possible to pass parameters to triggers?

1159

Define commit?

1053

What is an inner join sql?

1097

What is difference between nchar and nvarchar?

1097

Do ddl statements need commit?

1020

What is the difference between inner join and outer join?

1037

What is an intersect?

1156

How global cursor can be declare with dynamic trigger ?

2269

what is a cursor? : Sql dba

1063

What view means?

1023

What is rowid in sql?

1054

What is pl sql variable?

1034