Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 10416 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / sandeep kumar
select replace(regexp_replace(replace
('A.B....C.......D.........E........F','.',' '),'( )
{2,}',' '),' ','.') from dual
| Is This Answer Correct ? | 1 Yes | 13 No |
Post New Answer View All Answers
What is the non-clustered index in sql?
What is the maximum size of sqlite database?
What are the subsets of sql?
What trigger means?
What is normalization in sql?
What is partition by in sql?
What is the trigger in sql?
what is the difference between join and union? : Sql dba
how to run 'mysql' commands from a batch file? : Sql dba
How to create an array in pl/sql?
What is self-join and what is the requirement of self-join?
What is the process of debugging?
What is benefit of creating memory optimized table?
What is sql trigger example?
Can you join views in sql?
