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 table is left in left join?

992

Where can I learn sql for free?

977

how to convert dates to character strings? : Sql dba

1141

What is the difference between count 1 and count (*) in a sql query?

967

Enlist the characteristics of pl/sql?

1779

Why do we use partitions in sql?

1033

Is left join inner or outer?

1003

What is range partitioning?

948

Explain correlated query work?

1041

What are hotfixes and patches?

930

How do I access sql anywhere database?

952

how do you tune the slow running queries in oracle db , explain the methodology

2582

Is it mandatory for the primary key to be given a value when a new record is inserted?

1188

Which is faster subquery or join?

1191

What is union, minus and interact commands?

1272