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


Please Help Members By Posting Answers For Below Questions

What is the use of partition by in sql?

490


how can we submit a form without a submit button? : Sql dba

511


How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?

615


How is pl sql different from sql?

513


explain the difference between bool, tinyint and bit. : Sql dba

501






What is sqlite used for?

504


What is the difference between a procedure and a function?

474


How would you pass hints to the sql processor?

504


what are tables and fields? : Sql dba

546


How do we accept inputs from user during runtime?

530


What is thread join () in threading?

515


Can we use view in stored procedure?

486


How do I debug a stored procedure?

607


What is data abstraction in sql?

490


Explain foreign key in sql?

596