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

what is a tablespace? : Sql dba

1051

What are types of indexes in sql?

1082

What is meant by <> in sql?

978

How do you optimize a query?

998

What is $$ in sql?

990

Is primary key clustered index?

949

Why trigger is used in sql?

970

What are the 3 modes of parameter?

1154

What is java sql package?

1096

What are the datatypes available in pl/sql ?

1104

Write the alter statement to enable all the triggers on the t.students table.

1125

What is a table partition?

1131

How does postgresql compare to oracle/db2/ms sql server/informix?

1034

What are some emotional triggers?

985

Does postgresql run on the cloud?

1146