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 to run 'mysql' commands from a batch file? : Sql dba

1170

How do you add a column to a table?

1103

Explain mutating table error.

1261

describe mysql connection using mysql binary. : Sql dba

1121

Who is the owner of mysql database?

1107

What is pl sql block in dbms?

1055

What are the usages of sql?

1102

How do I view a procedure in sql?

1019

what is meant by urlencode and urldocode? : Sql dba

1240

What are the syntax and use of the coalesce function?

1274

What is procedure and function in sql?

1045

What is the difference between unique and primary key constraints?

1122

Does pl/sql support create command?

1168

How to revise and re-run the last sql command?

1218

What is denormalization in a database?

1107