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
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 is the use of partition by in sql?
how can we submit a form without a submit button? : Sql dba
How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?
How is pl sql different from sql?
explain the difference between bool, tinyint and bit. : Sql dba
What is sqlite used for?
What is the difference between a procedure and a function?
How would you pass hints to the sql processor?
what are tables and fields? : Sql dba
How do we accept inputs from user during runtime?
What is thread join () in threading?
Can we use view in stored procedure?
How do I debug a stored procedure?
What is data abstraction in sql?
Explain foreign key in sql?