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 trigger price?

0 Answers  

---

How do I view tables in sql developer?

0 Answers  

---

how do you login to mysql using unix shell? : Sql dba

0 Answers  

---

declare l1 number := null; l2 number :=null; begin if l1=l2 then message('equal'); else if l1<>l2 then message('not equal'); else message('else'); end if; end if; end; What will be the output ?

7 Answers   Oracle,

---

What is union and union all keyword in sql?

0 Answers  

---

Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

0 Answers   IBM,

---

What is the purpose of the primary key?

0 Answers  

---

Is left join inner or outer?

0 Answers  

---

What is range partitioning?

0 Answers  

---

how to select unique records from a table? : Sql dba

0 Answers  

---

What is primary key and foreign key?

0 Answers  

---

How is Oracle 10g helpful when compared to oracle 9i and what is grid computing

1 Answers   Flextronics,

---