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
- 10524 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / dilip kumar
SELECT REGEXP_REPLACE (
Replace ('A.B....C.......D.........E........F', '.', ' '),
'( ){1,}',
'.')
FROM DUAL;
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
how to drop an existing index in mysql? : Sql dba
Why should I use postgresql?
What is a sql*loader control file?
What are the different types of a subquery?
what's the difference between a primary key and a unique key? : Sql dba
What is dynamic sql in pl sql?
What is meaning of <> in sql?
What is the difference between python and sql?
What is trigger and stored procedure in sql?
What are the indexing methods?
What is sql in oracle?
what are the nonstandard string types? : Sql dba
Can you join a table to itself?
Explain the uses of a database trigger?
Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?
