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
- 8485 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / sreenivasulu sangatipalli
SELECT regexp_replace('A...B..C.D......E....F', '[.]+', '.') FROM DUAL;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are stored procedures in mysql?
what is dbms? : Sql dba
Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?
If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????
Why is theta join required?
What are the types of variables use in pl sql?
How do we accept inputs from user during runtime?
Is natural join same as inner join?
what is datawarehouse? : Sql dba
Mention what problem one might face while writing log information to a data-base table in pl/sql?
What is a common use of group by in sql?
How do I upgrade sql?
How do you take the union of two tables in sql?
Are stored procedures faster than queries?
How do I save the results of sql query in a file?
