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
10465 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 are all ddl commands?

1076

Explain the commit statement.

1151

Can you sum a count in sql?

995

How do I run a sql script?

1136

What are sql constraints?

1172

What is the source code of a program?

1063

what are date and time data types? : Sql dba

978

what is a primary key? : Sql dba

1029

Can a varchar be a primary key?

1005

What are the string functions in sql?

968

Explain ddl statements in pl/sql?

1002

How to display the current date in sql?

1069

How do rank () and dense_rank () differ?

1042

What is data control language (dcl)?

1131

Does pl/sql support create command?

1098