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 fmtonly in sql?

1010

Why do we use triggers?

916

what is difference between delete and truncate commands? : Sql dba

1067

What are basic techniques of indexing?

1325

How would you reference column values before and after you have inserted and deleted triggers?

1021

What is information schema in sql?

1017

How do I enable sql encryption?

969

How do I find duplicates in the same column?

1000

What are the events on which a database trigger can be based?

1103

What is a constraint? Tell me about its various levels.

1085

What's the difference between inner join and left join?

949

How does postgresql compare to "nosql"?

983

What is cost in sql execution plan?

909

What is the basic structure of an sql?

1033

What are the methods of filing?

878