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

What are the ddl commands?

1055

Is left join same as inner join?

1219

how to check server status with 'mysqladmin'? : Sql dba

1132

How do I view a sql trace file?

1063

What is rename in sql?

1018

How to avoid using cursors? What to use instead of cursor and in what cases to do so?

1248

Is sql a scripting language?

1086

what is 'mysqlshow'? : Sql dba

1076

Is crud a cuss word?

1073

What are the dml statements?

1196

What is restrict in sql?

1178

What are the different types of constraints?

1278

How to set up sql*plus output format in oracle?

1082

What is sql mysql pl sql oracle?

1129

What is use of trigger?

987