i have a word
***********hello********world******.
I require a o/p
**********hello world**********,
Need to delete the middle stars.
Answers were Sorted based on User's Feedback
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 |
Answer / ajit
select '******hello*****world*******' str,
rpad(lpad(replace('******hello*****world*******', '*'), 15, '*'), 20,'*') str1
from dual;
Is This Answer Correct ? | 1 Yes | 1 No |
Answer / mkarthikeyan
select replace('word ***********hello********world******. I
require a o/p **********hello world**********','*','') from
dual;
Is This Answer Correct ? | 1 Yes | 9 No |
Can we call procedure in select statement?
What do you mean by stored procedures?
What are the limitations of sql express?
Can we perform dml on view?
What is difference between hql and native sql?
How can I make sql query run faster?
Does a join table need a primary key?
What is a temp table?
what is bcp? When is it used?
how to enter numeric values as hex numbers? : Sql dba
Can we rename a column in the output of sql query?
Where is pl sql used?