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
- 10468 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / dilip kumar
SELECT REGEXP_REPLACE (
Replace ('A.B....C.......D.........E........F', '.', ' '),
'( ){1,}',
'.')
FROM DUAL;
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
what are the properties and different types of sub-queries? : Sql dba
What are all types of user defined functions?
what are the advantages and disadvantages of views in a database? : Sql dba
Do ddl statements need commit?
Is pl sql a programming language?
How can we optimize a sql query?
how can we know the count/number of elements of an array? : Sql dba
What pl/sql package consists of?
How is a PL/SQL code compiled?
The in operator may be used if you know the exact value you want to return for at least one of the columns.
Does execute immediate commit?
How exception handling is done in advance pl/sql?
how to start mysql server? : Sql dba
What are sql constraints?
Can we create a trigger on view?
