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
- 8589 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 the types pl/sql code blocks?
How do you modify a trigger?
write an sql query to find names of employee start with 'a'? : Sql dba
What is pl sql variable?
Differentiate between syntax and runtime errors.
what does it mean to have quoted_identifier on? : Sql dba
Can a table contain multiple foreign key’s?
What is 19 null in sql?
What is mutating error in pl sql?
Which is better join or subquery?
What do you mean by dbms? What are its different types?
How do you explain an index number?
Explain what is rdbms?
In pl/sql, what is bulk binding, and when/how would it help performance?
What is a record in pl/sql?
