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
- 8546 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / sunaksha
select REGEXP_REPLACE ('A.B....C.......D.........E........F','.{1,}',
'.') FROM DUAL;
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
What is a full join sql?
Does sql profiler affect performance?
Is it possible to update views?
How do you rank data in sql?
What is difference between table and view?
Does pdo prevent sql injection?
What is the difference between numeric and autonumber?
What is vector point function?
How do you create an update query?
How can I make sql query run faster?
how to create a new table in mysql? : Sql dba
how to convert dates to character strings? : Sql dba
Can we use update in sql function?
What is trigger price?
What is the life of an sql statement?
