SELECT regexp_replace('A...B..C.D......E....F', '[.]+',

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 / sreenivasulu sangatipalli

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

Answer Posted / sreenivasulu sangatipalli

SELECT regexp_replace('A...B..C.D......E....F', '[.]+', '.') FROM DUAL;

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Does truncate need commit?

924

What does stand for in sql?

953

What are actual parameters and formal parameters?

1084

What is on delete set null?

1072

How do I copy a table in sql?

966

what are rollup and cube in t-sql? : Transact sql

1072

Why is partition used in sql?

1105

How is pl sql different from sql?

1061

Why do we use function in pl sql?

1045

How do I run a script in sql developer?

936

How do we accept inputs from user during runtime?

1044

What is sql indexing?

1001

How do we use distinct statement? What is its use?

1013

Explain constraints in sql?

1028

Can we use insert statement in function?

982