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
- 8515 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / oddabout.com
SELECT replace(replace(replace('A.B....C.......D.........E........F','.',' @'),'@ ',''),' @','.') FROM dual
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
How to disable a trigger name update_salary?
How many types of cursors supported in pl/sql?
What type of database is cloud sql?
What type of join is sql join?
What are the various restrictions imposed on view in terms of dml?
How to assign sql query results to pl sql variables?
how mysql optimizes distinct? : Sql dba
How to read xml file in oracle pl sql?
What is case function?
Explain the difference between triggers and constraints?
Is sql port 1433 encrypted?
How do I audit the sql sent to the server?
Is sqlite good enough for production?
What is mutating table error?
How to select random rows from a table?
