SELECT REGEXP_REPLACE ( Replace ('A.B....C.......D.........E.....

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 / dilip kumar

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

Answer Posted / dilip kumar

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

Is This Answer Correct ?

3 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How would you reference column values before and after you have inserted and deleted triggers?

1065

What is a column in a table?

1126

What is group function in sql?

1024

What is where clause in sql?

1040

tell me about various levels of constraint. : Sql dba

1035

What is pl sql in oracle?

1043

Can function return multiple values in sql?

1060

How many types of normalization are there?

966

What is coalesce sql?

1001

How can we debug in PL/SQL?

1136

What are all different types of collation sensitivity?

1035

Why do we need unique key in a table?

957

What are different types of statements supported by sql?

1165

What is sqlerrm?

939

What is dml with example?

1089