select replace(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 / sandeep kumar

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

Answer Posted / sandeep kumar

select replace(regexp_replace(replace
('A.B....C.......D.........E........F','.',' '),'( )
{2,}',' '),' ','.') from dual

Is This Answer Correct ?

1 Yes

13 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is a variable in sql?

1001

what is a database transaction? : Sql dba

1183

Is pl sql and postgresql same?

1132

What is the difference between the conventional and direct path loader? : aql loader

1152

Explain the select statement in sql?

1110

what are all the common sql function? : Sql dba

1057

How many types of index are there?

1041

Can we edit a view in sql?

983

Can sql developer connect to db2?

1048

Write a query to display the current date in sql?

1020

How does sql*loader handles newline characters in a record? : aql loader

1045

How do temporal tables work?

958

What is a schema? How is it useful in sql servers?

1120

Is time a data type in sql?

906

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

1027