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 types of operators available in sql?

1011

what is self-join? : Sql dba

1057

Is primary key clustered or nonclustered?

954

How to fetch values from testtable1 that are not in testtable2 without using not keyword?

1158

Explain the select statement in sql?

1045

What can you do with pl sql?

1034

How to make a copy values from one column to another in sql?

985

What is scalar and vector?

940

What is the difference between the sql*loader and import utilities? : aql loader

980

How does cross join work?

877

What is assignment operator in pl sql?

970

What is the difference between the repeatable read and serializable isolation levels? : Transact sql

1017

Write the alter statement to enable all the triggers on the t.students table.

1069

What is the difference between an inner join and an outer join?

971

GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

3010