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
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 is the difference between blob and text? : Sql dba
what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba
What is clustered index in sql?
Explain the steps needed to create the scheduled job?
what is normalization? : Sql dba
what is a composite key ? : Sql dba
How do you delete data from a table?
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
What is meant by truncate in sql?
What are tuples in sql?
What is inner join in sql?
How to fetch values from testtable1 that are not in testtable2 without using not keyword?
Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?
How can check sql version from command line?
what are the security recommendations while using mysql? : Sql dba