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
- 10684 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
Why do you partition data?
How to rename a column in the output of sql query?
what is a unique key ? : Sql dba
How can you fetch common records from two tables?
How many types of primary keys are there?
What is sql integrity?
explain access control lists. : Sql dba
How do I create an index in word?
What is use of package in pl sql?
What is trigger in flip flop?
Explain unique key in sql.
How do you copy a table in sql?
Why do we create stored procedures & functions in pl/sql and how are they different?
Can you join views in sql?
What is update query?
