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;

Is record in oracle pl sql?

0 Answers  

---

How to run pl/sql statements in sql*plus?

0 Answers  

---

suppose I have two table one Emp and other is dpt. Emp table has a field ,dept id,name ,sal and dpt table has a field dept id,dept name. Now I want to find out the emplyee list whose sal is between 2000-3000 from dept x.

7 Answers   Geometric Software, IBM,

---

Is left join inner or outer?

0 Answers  

---

What is the current version of sql?

0 Answers  

---

How to retrieve Duplicate Rows only in a Table? Suppose if a Table Name is "Education". It consists of multiple columns. Then if we insert rows into this table with duplicate records then how can we retrieve only duplicate records from that table?

29 Answers   Alps, Aricent, Bank Of America, Wipro,

---

Which software is used for pl sql programming?

0 Answers  

---

Are pl sql variables case sensitive?

0 Answers  

---

What is bulk collect in pl sql?

0 Answers  

---

What is the use of double ampersand (&&) in sql queries? Give an example

0 Answers  

---

What is difference between triggers and stored procedures. And advantages of SP over triggers ?

4 Answers   Microsoft, TCS,

---

What is the use of time stamp in select statement?

1 Answers   TCS,

---