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
10689 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

Why we use pl sql?

1006

Explain the structure of pl/sql in brief.

1135

What plvcmt and plvrb does in pl/sql?

1362

How does join work in sql?

1050

Does pl/sql support create command?

1168

What is the difference between pl and sql?

1153

Can we use the cursor's to create the collection in PL/SQL?

1086

What sql does db2 use?

1028

What is union, minus and interact commands?

1361

How do I start sql profiler?

1046

what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba

1090

how do you login to mysql using unix shell? : Sql dba

1118

How to install oracle sql developer?

1095

How many sql core licenses do I need?

994

What will you get by the cursor attribute sql%notfound?

1125