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
10226 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 are the benefits of pl/sql packages?

1031

How many parts of a pl sql block are optional?

1029

What is aggregate function in sql?

983

What is dialect in sql?

887

Is crud a cuss word?

971

What is record type in pl sql?

931

what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?

2411

What is the benefit of foreign key?

960

How do you explain an index?

1221

Which is faster truncate or drop?

978

how to show all tables with 'mysql'? : Sql dba

1058

What are the types of queries in sql?

1012

Is sql sequential or random?

980

What is compute?

1010

Is trigger a stored procedure?

884