Difference between SUBSTR and INSTR?

3 Answers  

---

Write a pl/sql script to display the following series of numbers: 99,96,93……9,6,3?

1 Answers  

---

how can we destroy the session, how can we unset the variable of a session? : Sql dba

0 Answers  

---

What is where clause in sql?

0 Answers  

---

How do I run a program in pl sql?

0 Answers  

---

---

what is switch column,colums cost in oracle?

0 Answers   Metric Stream,

---

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

1 Answers  

---

What is a trigger in pl/sql?

1 Answers  

---

What are analytic functions in sql?

0 Answers  

---

what is row? : Sql dba

0 Answers  

---

Give an example of Full Outer Join?

1 Answers   IBM,

---

We have a CURSOR then we need BULK COLLECT?

1 Answers  

---