Answer / anil kumar jampana

cursor is a private sql area. pl/sql cann't handle multy
row select statements. Inorder to handle mulyrow select
statements, we are using cursors.

Answer / raam

Cursor is a private memory area. to perform transations on
morethan one row we are using cursors. required multi-
records will be fetched to cursor area and will do
operations on those records. It is a temperary memory area.
Winthout Cursor pl/sql can perform only one record at a
time.

Answer / suresh

cursor is private sql area. cursor is used for to retrieve
or display the more than one values at a time.

What is difference between a PROCEDURE & FUNCTION ?

6 Answers   Satyam,

---

What is the starting oracle error number? What is meant by forward declaration in functions?

0 Answers  

---

Are left and right joins the same?

0 Answers  

---

How to get each name only once from an employee table?

0 Answers  

---

Write a procedure to return the month and the number of developers joined in each month (cursor )

2 Answers   Tech Mahindra,

---

---

What is a mutating table and a constraining table?

0 Answers  

---

What is the syntax and use of the coalesce function?

0 Answers  

---

When do we create bitmap indexes

2 Answers   CTS,

---

How do you bind variables in pl sql?

0 Answers  

---

What are procedures used for?

0 Answers  

---

I have one Excel file with 1,50,000 Records. Now I need to load that whole file into Oracle Database with same columns in Excel sheet . I need PLSQL Procedure or used by SQL PLUS

7 Answers   Polaris,

---

What is indexing in sql and its types?

0 Answers  

---