Answer / chandan kumar

select (substr('***********hello********world******',1,instr
('***********hello********world******','o',1) )
||' '||substr('***********hello********world******',instr
('***********hello********world******','w',1) )
)
from dual

Answer / ajit

select '******hello*****world*******' str,
rpad(lpad(replace('******hello*****world*******', '*'), 15, '*'), 20,'*') str1
from dual;

Answer / mkarthikeyan

select replace('word ***********hello********world******. I
require a o/p **********hello world**********','*','') from
dual;

how to create a primary key with out creating an index?

9 Answers   TCS,

---

Why we use triggers in mysql?

0 Answers  

---

write a pl/sql function if enter a value=0 then output value=1 and vise verse with out using if and case statements.

3 Answers   Zensar,

---

What is a sql*loader control file?

0 Answers  

---

What are tuples in sql?

0 Answers  

---

---

what are the methods using performance tunning in sql and pl/sql

2 Answers  

---

What does data normalization mean?

0 Answers  

---

Give the order of sql select?

0 Answers  

---

How to add, remove, modify users using sql?

0 Answers  

---

Which data type is a composite type?

0 Answers  

---

Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

0 Answers   MCN Solutions,

---

Differentiate between % rowtype and type record.

0 Answers  

---