select (substr('***********hello********world******',1,instr (&#

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

Question Posted / chandan kumar

3 Answers
6658 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

Please Help Members By Posting Answers For Below Questions

What is join view in sql?

899

What is an index? What are the types of indexes? How many clustered indexes can be created on a table?

994

What is sql scripting?

1037

define data blocks ? : Sql dba

932

Which is better join or inner query?

962

Can I copy :old and :new pseudo-records in/to an oracle stored procedure?

1144

what is union, minus and interact commands? : Sql dba

1123

What does closing a cursor do?

1247

What are the two types of cursors in pl sql?

1004

How do you write an inner join query?

892

Explain the steps needed to create the scheduled job?

969

What is embedded sql with example?

989

Why trigger is used in sql?

917

How do I run a sql query?

969

What are the benefits of pl/sql packages?

1034