Answer Posted / chandan kumar

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

What are all different types of collation sensitivity?

1015

---

Name the different types of indexes in sql and define them.

1120

---

How do I run a program in pl sql?

988

---

Can I call a procedure inside a function?

986

---

What is union and union all keyword in sql?

1018

---

How do you update a sql procedure?

1012

---

explain the options of myisamchk to improve the performance of a table. : Sql dba

992

---

What does the base_object_type column shows in the user.triggers data dictionary view?

1029

---

What is difference between function and trigger?

1024

---

Does postgresql run on the cloud?

1128

---

how to use in conditions? : Sql dba

993

---

i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5

4001

---

What is a recursive join sql?

1051

---

What is a null value?

1125

---

How to call a javascript function from pl sql?

1119

---