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

What does rownum mean in sql?

1011

What is the purpose of my sql?

938

What is sql mysql pl sql oracle?

1059

How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?

1032

Is left join same as join?

972

Which data type is a composite type?

974

Does sql between include endpoints?

989

How can I speed up sql query?

938

what is a relationship and what are they? : Sql dba

1076

What is a full join sql?

1035

Can I learn sql in a week?

1044

Write a query to display the current date in sql?

1005

What is substitution variable?

1032

What are the possible values for the boolean data field?

941

What do you understand by pl/sql cursors?

1072