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

What is the advantage of index in sql?

697

What is natural join in sql?

720

How show all rows in sql?

803

what is denormalization. : Sql dba

785

Are sql connections encrypted?

764

What is sql*plus?

785

how can we take a backup of a mysql table and how can we restore it. ? : Sql dba

731

what are the advantages a stored procedure? : Sql dba

728

What is function and procedure in pl sql?

717

How to know the last executed procedure?

815

what are dynamic queries in t-sql? : Transact sql

751

what is a constraint? Tell me about its various levels. : Sql dba

747

What is sqlcommand?

751

What is cascade in sql?

712

what is a materialized view? : Sql dba

764