What is difference between a Cursor declared in a procedure and Cursor declared in a package specification ?

2 Answers   JDA,

---

Does sql profiler affect performance?

0 Answers  

---

Define a temp table?

0 Answers  

---

Can we write create command in the plsql block?if possible how?

2 Answers  

---

What is the use of sqldataadapter?

0 Answers  

---

What is the requirement of self-join?

0 Answers  

---

how are rank and dense rank being alloted for column with same values over a particular column

1 Answers  

---

How many sql are there?

0 Answers  

---

how to see the oracle 9i/10g table in pc? or In my pc where the table is saved and how to see?

1 Answers  

---

What is loop in pl sql?

0 Answers  

---

ename empno deptno amar 1 10 akbar 2 20 anthonny 3 30 jonathan 4 40 write a procedure to dispaly the column values ina row separated by a deleimiter eg - input - select ename from emp '|' output - amar|akbar|anthony|jonathan input - select empno from emp '@' o/p - 1@2@3@4 input - select deptno from emp '/' o/p - 10/20/30/40 Pls answer this questn.

2 Answers  

---

Why do we need sharding?

0 Answers  

---