SELECT replace(replace(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 / oddabout.com

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

Answer Posted / oddabout.com

SELECT replace(replace(replace('A.B....C.......D.........E........F','.',' @'),'@ ',''),' @','.') FROM dual

Is This Answer Correct ?

8 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How can I delete duplicate rows?

963

Can you call pl/sql package functions from within a fast formula?

971

What is union, minus and interact commands?

1211

Which is faster count (*) or count 1?

963

Can we perform dml on view?

971

What is the current version of sql?

970

If the application is running very slow? At what points you need to go about the database in order to improve the performance?

944

What are different types of indexes?

957

What is parallel hint?

1217

How many clustered indexes can you have?

924

Is pl sql a scripting language?

969

What is pivot query?

1013

What is blind sql injection?

990

Show code of a cursor for loop.

999

What are the two types of exceptions in pl/sql?

962