SELECT REGEXP_REPLACE ( Replace ('A.B....C.......D.........E.....

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

Question Posted / dilip kumar

6 Answers
10232 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

Please Help Members By Posting Answers For Below Questions

What is program debugging?

1129

What is sqlservr exe?

941

What is not equal in sql?

1006

How to read/write files from pl/sql?

992

What are the types of subqueries?

1014

Is and as keyword in pl sql?

904

What is the use of stored procedures?

975

Does pl sql work in mysql?

919

Does sqlite need a server?

994

What is a natural join sql?

920

Which table is left in join?

914

What is form and report?

926

what is commit? : Sql dba

1026

Write a unique difference between a function and a stored procedure.

924

What are stored procedures used for?

960