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
Is pl sql still used?
What is rownum and rowid?
What is lexical units in pl sql?
How to place comments in pl/sql?
What is compiled query?
- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?
Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?
Which is better join or inner query?
What does := mean in pl sql?
What is the difference between microsoft access and sql server?
Is natural join same as inner join?
what is an alias command? : Sql dba
Explain the working of foreign key?
what is the use of set statement in tsql? : Transact sql
how to delete an existing column in a table? : Sql dba