select replace('word ***********hello********world******. I require a

i have a word
***********hello********world******.
I require a o/p
**********hello world**********,
Need to delete the middle stars.

Question Posted / mkarthikeyan

Answer Posted / mkarthikeyan

select replace('word ***********hello********world******. I
require a o/p **********hello world**********','*','') from
dual;

Is This Answer Correct ?

1 Yes

9 No

Please Help Members By Posting Answers For Below Questions

Which are the different types of indexes in sql?

1099

what is an alias command? : Sql dba

1170

What are character functions?

1141

what is the difference between join and union? : Sql dba

1202

How can a pl sql block be executed?

1004

What is constant in pl sql?

1063

What is dbo in sql?

1019

What is structural independence and why is it important?

1074

Which nosql database is best?

1025

Is sql dba a good career? : SQL DBA

1049

What is rownum in sql?

1093

What is the difference between a primary key and a clustered index?

1035

Can we write dml inside a function in sql server?

1004

What is the purpose of my sql?

1011

What is %rowtype in pl sql?

1030