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 are the topics in pl sql?
What is varray in pl sql?
what is union, minus and interact commands? : Sql dba
How do I run a pl sql program?
When you have to use a default "rollback to" savepoint of plvlog?
How does an execution block start and end in pl sql?
Can a foreign key be a duplicate?
What is the difference between microsoft access and sql server?
Explain the methods used to protect source code of pl/sql.
Explain the significance of the & and && operators in pl sql.
What is indexing oracle sql?
define sql delete statement ? : Sql dba
How do you define a foreign key?
Does sql*plus have a pl/sql engine?
What do you understand by pl/sql records?