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
- 10422 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / sunaksha
select REGEXP_REPLACE ('A.B....C.......D.........E........F','.{1,}',
'.') FROM DUAL;
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
What are different methods to trace the pl/sql code?
What are two statement types in sql?
What is primary key and unique key?
Explain what is table in a database?
How do sql triggers work?
What is tuple in sql?
what are the different functions in sorting an array? : Sql dba
What are aggregate functions in sql?
Explain about various levels of constraint.
What is a stored procedure in sql with example?
What does pragma mean?
Why we use pl sql?
Why is partition used in sql?
How do you explain an index?
what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?
