i have a word ***********hello********world******. I require a o/p **********

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

Question Posted / murugesh

3 Answers
5537 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

i have a word ***********hello********world******. I require a o/p **********hello world*********..

Answer / chandan kumar

select (substr('***********hello********world******',1,instr
('***********hello********world******','o',1) )
||' '||substr('***********hello********world******',instr
('***********hello********world******','w',1) )
)
from dual

Is This Answer Correct ?

10 Yes

2 No

i have a word ***********hello********world******. I require a o/p **********hello world*********..

Answer / ajit

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

Is This Answer Correct ?

1 Yes

1 No

i have a word ***********hello********world******. I require a o/p **********hello world*********..

Answer / mkarthikeyan

select replace('word ***********hello********world******. I
require a o/p **********hello world**********','*','') from
dual;

Is This Answer Correct ?

1 Yes

9 No

Post New Answer