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
- 9325 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 string data type in sql?
what are the authentication modes in sql server? How can it be changed? : Sql dba
What is an inner join sql?
How do I find duplicates in two columns?
What is the maximum number of rows in sql table?
What are all the ddl commands?
what is the different between now() and current_date()? : Sql dba
What is self-join and what is the requirement of self-join?
What is bind variable in pl sql?
What are the types of subqueries?
What is use of trigger?
Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?
What does (+) mean in sql joins?
How you improve the performance of sql*loader? : aql loader
Can we use ddl statements in stored procedure sql server?
