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 / sandeep kumar
select replace(regexp_replace(replace
('A.B....C.......D.........E........F','.',' '),'( )
{2,}',' '),' ','.') from dual
Is This Answer Correct ? | 1 Yes | 13 No |
Post New Answer View All Answers
How to pipe multiline string to isql?
Why do we use cursors?
How do I filter in sql profiler?
What is the difference between function and procedure in pl/sql?
What is a sql trace file?
Why trigger is used in sql?
What is the main reason behind using an index?
Why are indexes and views important to an organization?
Is sql free?
Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?
What can I use instead of union in sql?
explain normalization concept? : Sql dba
How do we accept inputs from user during runtime?
Can we join tables without foreign key?
Where is pl sql used?