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 are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

958

How can I speed up sql query?

966

what is the syntax used for partition in tsql? : Transact sql

1015

What is sql dialect?

1122

What are the parameter modes supported by pl/sql?

1112

What is range partitioning?

972

Is full outer join same as cross join?

973

Which tcp/ip port does sql server run on? How can it be changed? : Sql dba

1003

Define select, insert, create, delete, update, drop keywords

1052

What is mdf ldf and ndf?

1002

How is a PL/SQL code compiled?

1236

Is mariadb a nosql database?

1056

how can we submit a form without a submit button? : Sql dba

995

Do we need to rebuild index after truncate?

1036

what is collation? : Sql dba

1158