Explain the difference between cursor declared in procedures and cursors declared in the package specification?

0 Answers  

---

How do I create a memory optimized filegroup?

0 Answers  

---

Can pl sql procedure have a return statement?

0 Answers  

---

hi this is nakka i have been looking for 1+ exp in oracle sql,plsql developer positions also have knoledge on d2k i am not getting proper walkins how to know it? where can i find it?

5 Answers  

---

Why is pl sql used?

0 Answers  

---

How do I quit sql?

0 Answers  

---

What is oracle sql called?

0 Answers  

---

how to achieve this problem?i am having table with two colums like empno,gender. in gender column, i am having records male,female like that .my final output will be male female 5 6

4 Answers   Hexaware,

---

Use The Implicit cursor to Query The Department table information Where Deptno is 30.check,if no record was found then print "Record Was Not Found".Else Print Deptname And Ename.Dept table Have Dname Varchar2(20),Deptno Number,EnameVarchar2(20).Please Answer In 2 mins,with in Maximum 15 lines.

5 Answers   Wipro,

---

Why do we go for stored procedures?

0 Answers  

---

What are the cursor attributes used in PL/SQL ?

4 Answers  

---

how to create object in plsql

2 Answers   TCS,

---