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

what is self join and what is the requirement of self join? : Sql dba

1145

What is sql deadlock?

1145

explain advantages of innodb over myisam. : Sql dba

1130

How do I find sql profiler?

944

Which join is like an inner join?

1028

How do you define a foreign key?

1005

Which operator is used in query for pattern matching?

1089

What is a sql profiler?

1028

How to run sql commands in sql*plus?

1183

What is mutating error?

968

How do I write a cron which will run a sql query and mail the results to agroup?

981

How can you save or place your msg in a table?

1002

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

1323

what is 'mysqladmin' in mysql? : Sql dba

1026

What sql database should I use?

1145