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;

What does a pl/sql package consist of?

0 Answers  

---

How do I use google cloud in sql?

0 Answers  

---

Whis is not false in primary key?

0 Answers   Fintellix,

---

Can we use the cursor's to create the collection in PL/SQL?

0 Answers   MCN Solutions,

---

What is identity column in sql server?

0 Answers  

---

---

Explain correlated query work?

0 Answers  

---

What happens if a procedure that updates a column of table X is called in a database trigger of the same table ?

1 Answers  

---

What is integrity constraints?

5 Answers   Ramco, Satyam,

---

Can We write bulk collect statement in triggers?

1 Answers   Polaris,

---

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

0 Answers  

---

How did you export data from database to excel file.

1 Answers   TCS,

---

scope of exception handling in plsql

4 Answers   Wipro,

---