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
6943 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 are the parameter modes supported by pl/sql?

1154

How do you update f as m and m as f from the below table testtable?

1930

Where not exists in sql?

1032

How to get unique records from a table?

1021

What is a schema sql?

1226

What are the sql versions?

999

Can we update views in sql?

989

list out some tools through which we can draw e-r diagrams for mysql. : Sql dba

1017

Write a sql select query that only returns each name only once from a table?

1077

Is ms sql traffic encrypted?

962

Explain the working of foreign key?

1136

Can we create table inside stored procedure?

1013

what is sql server agent? : Sql dba

1158

How is sql used in oracle?

1037

Can delete statement be rollbacked?

1031