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

Are dml statements autocommit?

1023

Can sql developer connect to db2?

1012

What is parallel hint?

1295

Define the select into statement.

1033

Does sql use python?

1013

Which constraints we can use while creating database in sql?

1055

What is procedure explain with example?

936

What is the plv (pl/vision) package offers?

1027

How do you delete duplicates in sql query using rowid?

924

what is a control file ? : Sql dba

1017

What is a heap in sql?

1044

What is the difference between drop and truncate commands?

1045

what is a trigger in mysql? : Sql dba

1128

What is dense_rank in sql?

954

Does inner join return duplicate rows?

962