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

Does execute immediate commit?

1223

Should I use mbr or gpt?

1029

Does truncate table reset auto increment?

1002

What is difference between pls_integer and integer?

969

How do I create a sql database?

1007

What is an implicit commit?

1058

What are the differences between implicit and explicit cursors?

1071

What does data normalization mean?

976

What is error ora-12154: tns:could not resolve the connect identifier specified?

1084

What is the difference between distinct and unique in sql?

956

Can a foreign key have a different name?

943

How do you write a complex sql query?

1092

What do you understand by case manipulation functions?

1040

How to Execute a Package in PL/SQL.?

1211

can sql servers linked to other servers like oracle? : Sql dba

1013