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
- 9337 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / sreenivasulu sangatipalli
SELECT regexp_replace('A...B..C.D......E....F', '[.]+', '.') FROM DUAL;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are all the different normalization?
What is the difference among union, minus and intersect?
What is the difference between left join and right join?
What are the two characteristics of a primary key?
What is pl sql script?
What is schema in sql?
Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?
How do you determine the current isolation level? : Transact sql
What is the difference between union and union all command?
What is cursor in pl sql?
Is sql scripting language?
What is rank dense_rank and partition in sql?
Why do we need a foreign key?
when is the use of update_statistics command? : Sql dba
How global cursor can be declare with dynamic trigger ?
