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
- 10493 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
What is normalisation in sql?
Is pl sql a scripting language?
Explain the uses of database trigger.
What is bitemporal narrowing?
Explain the types of joins in sql?
What is a sql trace file?
how to create a new table in mysql? : Sql dba
How do I view a table in sql?
What are the different ddl commands in sql?
what is the stuff function and how does it differ from the replace function? : Sql dba
How many scalar data types are supported in pl/sql?
What is a file delimiter?
Why do we need cursors in pl sql?
What is fmtonly in sql?
What is the difference between syntax error and runtime error?
