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
- 8551 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
Does sql*plus also have a pl/sql engine?
What is primary key secondary key alternate key candidate key?
Why is the cursor important?
What is left join example?
How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000
Which data type is a composite type?
What are the various levels of constraints?
What is the purpose of primary key?
What is materialized view in sql?
Can we alter stored procedure?
What is parallel hint?
how to enter characters as hex numbers? : Sql dba
Can we use having without group by in sql?
Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql
What is sql scripting?
