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
- 6 Answers
- 8548 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
Does asenumerable execute the query?
How do you declare a user-defined exception?
What if we write return in procedure?
what are the performance and scalability characteristics of mysql? : Sql dba
How to use sql statements in pl/sql?
What is on delete set null?
What is nvl?
define join and explain different type of joins? : Sql dba
What does a pl/sql package consist of?
what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba
what are the differences between char and varchar? : Sql dba
What is memory optimized table?
How to make a copy values from one column to another in sql?
What is difference between joins and union?
Name the operator which is used in the query for pattern matching?
