i have a word
***********hello********world******.
I require a o/p
**********hello world**********,
Need to delete the middle stars.
Answer Posted / 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 |
Post New Answer View All Answers
Explain two easy sql optimizations.
what is log shipping? : Sql dba
What is query syntax?
What is rtm stands for?
What does select count (*) mean in sql?
What is difference between function and trigger?
How do I find sql profiler?
How to test for null values?
What is a .db file?
What is where clause in sql?
What is join view in sql?
Why we use triggers in mysql?
what is sub-query? : Transact sql
What is an index in sql with example?
What is difference between procedure and trigger?