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

What is pl sql in oracle?

788

Explian rowid, rownum?

756

Explain the working of foreign key?

729

Is keyword pl sql?

732

Can you load data into multiple tables at once? : aql loader

802

How to know the last executed procedure?

809

Why use stored procedures?

774

Explain about various levels of constraint.

702

Are sql database names case sensitive?

689

List the different type of joins?

752

What is pivot table in sql?

741

what are the advantages of sql ? : Sql dba

742

How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?

800

What is an implicit commit?

762

What are the different types of sql commands?

787