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
- 10458 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 enums used for in mysql? : Sql dba
Does normalization improve performance?
what is sql in mysql? : Sql dba
How can we implement rollback or commit statement in a trigger?
What is execution plan in sql?
Which version of sql do I have?
What is transaction control language (tcl)?
tell us something about heap tables. : Sql dba
What is loop in pl sql?
What are the features of pl sql?
how can we destroy the cookie? : Sql dba
What is an exception in PL/SQL? What are the two types of exceptions?
What is on delete restrict?
How many clustered indexes can you have?
Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints
