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
- 10707 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / anuradha
SELECT REGEXP_REPLACE (
REPLACE ('A.B....C.......D.........E........F', '.', ' '),
'( ){2,}',
'.')
FROM DUAL;
| Is This Answer Correct ? | 3 Yes | 5 No |
Post New Answer View All Answers
What is the difference between execution of triggers and stored procedures?
How global cursor can be declare with dynamic trigger ?
What is primary key and unique key?
Compare sql & pl/sql
How to prepare for oracle pl sql certification?
What are different clauses used in sql?
Sql technical questions
What is record type in pl sql?
What is rownum in sql?
Explain lock escalation? : Transact sql
what does the t-sql command ident_incr does? : Transact sql
Are left and right joins the same?
How to run sql functions in pl/sql?
Why do we use partitions in sql?
How to use sql*plus built-in timers?
