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
- 10515 Views
- IBM, I also Faced
- E-Mail Answers
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 makes a good primary key?
What is the left table in sql?
Why should I use postgresql?
What are the two types of exceptions in pl/sql?
Do we need to create index on primary key?
What is sql injection vulnerability?
How to write pl sql program in mysql command prompt?
What is pl sql and why it is used for?
What is Materialized View? In What Scenario we Use Materialized View?
What is data type in database?
What is difference between nchar and nvarchar?
Determine if oracle date is on a weekend?
how do you tune the slow running queries in oracle db , explain the methodology
How do you write an inner join query?
Why is normalization important?
