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

What is cascade in sql?

1014

How can you load multi line records? : aql loader

1124

Determine if oracle date is on a weekend?

1087

Can we use rowid as primary key?

1041

What is cursor explain with example?

1027

What is pivot query?

1119

Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

1269

What are pl/sql packages?

1154

What is the file extension for sql database?

1062

What is the maximum size of sqlite database?

1153

What are the subsets of sql?

1194

What are the commands used in sql?

1130

What is pivot in sql?

969

What is dynamic sql in pl sql?

1088

what happens if you no create privilege in a database? : Sql dba

1045