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
6816 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 a pragma statement?

1265

how to convert character strings to numeric values? : Sql dba

1112

how would concatenate strings in mysql? : Sql dba

1098

What is mutating error in pl sql?

1022

How to order siblings in oracle hierarchy queries?

1048

Does sql*plus also have a pl/sql engine?

1082

Is sql database free?

983

How does one use sql*loader to load images, sound clips and documents? : aql loader

1187

How can we avoid duplicating records in a query?

984

How do I debug a stored procedure?

1117

What is a primary key sql?

1046

column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.

7355

How can we make an if statement within a select statement?

1015

What is execute immediate?

1087

how to add a new column to an existing table in mysql? : Sql dba

1073