Answer Posted / suresh kumar somayajula

Cursor : It's a private SQL worksheet area where we can
execute SQL commands and processing information.
The purpose of the Cursor is, PL/SQL execution block will
process only one records means it will return only one
records.If we want to retrieve or process more number of
records we use the "Cursors".
These are of two types.
1. Implicit Cursor 2. Explicit cursors.

Thank you,
Suresh

How to assign sql query results to pl sql variables?

1145

---

Why self join is used in sql?

1028

---

What are analytical functions in sql?

1076

---

what is error ora-03113: end-of-file on communication channel?

1226

---

What is the use of <> sql?

1038

---

What is the primary use of normalization?

1053

---

What is scope and visibility in PL/SQL?

1288

---

Why are cursors used?

1173

---

What are the types pl/sql code blocks?

1195

---

What does a pl/sql package consist of?

1015

---

What is the difference between nvl function, ifnull function, and isnull function?

1154

---

ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..

2552

---

What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql

1056

---

What is oracle and pl sql?

1159

---

What is normalisation in sql?

1098

---