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
- 6 Answers
- 9336 Views
- IBM, I also Faced
- E-Mail Answers
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
Define commit, rollback and savepoint?
Can you inner join the same table?
What are pl sql procedures?
What is pl sql block in dbms?
What are the types of sql commands?
what are the differences between binary and varbinary? : Sql dba
Why are aggregate functions called so?
How many parts of a pl sql block are optional?
what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba
Explain the purpose of %type and %rowtype data types?
Explain unique key in sql.
what is union, minus and interact commands? : Sql dba
Is stored procedure faster than query?
Can we use two order by clause in query?
What is a data manipulation language?
