How to return an array from java to pl/sql?

0 Answers  

---

can i give user defined exception in a package

2 Answers  

---

If a cursor is open, how can we find in a pl/sql block?

0 Answers  

---

How will you debug your procedure? If your procedure is around 2000 lines and the expected output is 10 and we get only output 5.So how will you debug it? Somebody pls give the correct answer?

2 Answers   Fidelity,

---

how to use 'mysql' to run sql statements? : Sql dba

0 Answers  

---

---

How collections are improve the performance?

1 Answers   Polaris,

---

How can you tell the difference between an index and a view?

0 Answers  

---

Why join is faster than subquery?

0 Answers  

---

What is partition in sql query?

0 Answers  

---

What is sql*plus?

0 Answers  

---

I i have 2 tables A & B ,A contains 10 records B contains 20 records ,what w'll be the o/p if we perform equijoin,outer join,right outer join,left outer join,full outer join,cross join seperately Can anyone help on this?

2 Answers  

---

If i insert record in table A and these record should update in table B by using Trigger.How to achieve this.

4 Answers   Saama Tech, TCS,

---