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.

how to create a new view in mysql? : Sql dba

1 Answers  

---

I have a Employee table with columns ename,eid,salary,deptno. How to retrieve sum of salary for each deptno?

8 Answers   L&T,

---

Can we join more than 2 tables in sql?

1 Answers  

---

What is a parameter query?

1 Answers  

---

What is cross join sql?

1 Answers  

---

Which constraints we can use while creating database in sql?

1 Answers  

---

what is isam? : Sql dba

1 Answers  

---

What is null in pl/sql?

1 Answers  

---

How are sql commands classified?

1 Answers  

---

What is difference between stored function and application function?

1 Answers  

---

How do I run a pl sql program?

1 Answers  

---

Write the command to remove all players named sachin from the players table.

1 Answers  

---