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
What are tables in sql?
What are the set operators in sql?
What is trigger explain it?
What does := mean in pl sql?
Which is better join or inner query?
how to load data files into tables with 'mysqlimport'? : Sql dba
What is union and union all keyword in sql?
Explain what is sql?
What is index example?
What are the benefits of triggers?
What is java sql driver?
what is a record in a database ? : Sql dba
what is acid property in database? : Sql dba
Why commit is not used in triggers?
How many clustered indexes can be created on a table?