select '******hello*****world*******' str, rpad(lpad(replace(�

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

Question Posted / ajit

Answer Posted / ajit

select '******hello*****world*******' str,
rpad(lpad(replace('******hello*****world*******', '*'), 15, '*'), 20,'*') str1
from dual;

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How do I start pl sql?

935

what is an alias command? : Sql dba

1077

How do you pronounce sql?

991

How do sql databases work?

984

How run sql*plus commands that are stored in a local file?

1044

How to run sql*plus commands in sql developer?

1136

How do you delete duplicates in sql query using rowid?

930

what are set operators in sql? : Sql dba

1027

List the different type of joins?

1057

What is the difference between truncate and drop statements?

1169

What is pl/sql language case sensitive?

1105

Why is sql*loader direct path so fast?

1094

What are conditional predicates?

1036

what is dbms? : Sql dba

975

How does sql developer connect to oracle database?

986