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 / anuradha

6 Answers
10467 Views
IBM, I also Faced
E-Mail Answers

Answer Posted / anuradha

SELECT REGEXP_REPLACE (
REPLACE ('A.B....C.......D.........E........F', '.', ' '),
'( ){2,}',
'.')
FROM DUAL;

Is This Answer Correct ?

3 Yes

5 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How delete a row in sql?

987

What is information schema in sql?

1067

What is a record in pl/sql?

1137

How can we solve sql error: ora-00904: invalid identifier?

1243

Does sap use sql?

977

What is the difference between count 1 and count (*) in a sql query?

981

Is truncate ddl or dml?

989

what is the use of friend function? : Sql dba

1017

what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure

1644

Why is stored procedure faster than query?

950

What is sql and db2?

993

What is java sql connection?

1042

How many types of sql are there?

984

Why is theta join required?

1140

Does truncate need commit?

938