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
Answer Posted / dilip kumar
SELECT REGEXP_REPLACE (
Replace ('A.B....C.......D.........E........F', '.', ' '),
'( ){1,}',
'.')
FROM DUAL;
Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
What is materialized view. What are different methods of refresh?
What are analytic functions in sql?
What is the purpose of the partition table?
How many types of privileges are available in sql?
Is mariadb a nosql database?
How do you create an update query?
Can we create clustered index without primary key?
how to show all tables with 'mysql'? : Sql dba
What is a join?
Explain mutating table error.
What is sqlite format?
What is latest version of sql?
What is trigger in flip flop?
Is time a data type in sql?
what is msql? : Sql dba