i have a word
***********hello********world******.
I require a o/p
**********hello world**********,
Need to delete the middle stars.
- 3 Answers
- 6030 Views
- I also Faced
- E-Mail Answers
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 variables in pl sql?
What is a sql instance vs database?
How to run pl/sql statements in sql*plus?
where are cookies actually stored on the hard disk? : Sql dba
Should I use mbr or gpt?
What is a nested table in word?
What are some predefined exceptions in pl/sql?
What is record variable?
What is sql constant?
How do I audit the sql sent to the server?
Can we join same table in sql?
Can a procedure in a package be overloaded?
Why do we use %rowtype & %type in plsql?
What is sql used for?
How to connect a sql*plus session to an oracle server?
