Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 10697 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
What is assignment operator in pl sql?
What are some predefined exceptions in pl/sql?
What is the difference between nvl function, ifnull function, and isnull function?
What is sqlservr exe?
What is a sql schema used for?
What does the acronym acid stand for in database management?
what is cursor. write example of it. What are the attributes of cursor.
What is rownum in sql?
What is difference between hql and sql?
What is bulk compiling in pl/sql.?
What are the three pl sql block types?
What is the difference between alter trigger and drop trigger statements?
What is %s in sql?
What are the types of dbms?
How consistent is the view of the data between and within multiple sessions, transactions or statements ?
