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 / 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 “go” in t-sql? : Transact sql
What types of commands can be executed in sql*plus?
How do I restart sql?
Which are the different character-manipulation functions in sql?
what is 'mysqlimport'? : Sql dba
Is pl sql a scripting language?
how can we submit a form without a submit button? : Sql dba
What is case function?
How to revise and re-run the last sql command?
Where can I learn sql for free?
How can you fetch first 5 characters of the string?
Sql technical questions
what are rollup and cube in t-sql? : Transact sql
What is sql keyword?
what is column? : Sql dba