Answer Posted / vaibhavi_dixit

Whenever a statement is send by user to Oracle server for
execution, a memory is allocated in which the statement is
executed,records are fetched and send back to user.Once
records are sent the memory is deallocated.This memory area
is know as implicit cursors and the selected records are
known as "Active set".Implicit cursors are handled by
Oracle and user does not have control on it.But in case user
(programmer) needs to have control then one can declare
explicit cursors.In Explicit cursors, cursor is
declared,when it is opened, the stament is executed, and
the data is fetched in memory.The records will remain in
memory, till programmer does not close the cursor.The
advantage of this is ,one can select 'n' no of records and
fetch one by one.Also one can pass parameters to cursors
for getting new set of records.
Procedure is nothing but named PL/SQL block which can be
individually executed or can be called from other procedure
or function.It is stored as an object in database schema.
One can acheive polymorphism in procedures if they are a
part of package.
Cheers
vd

Is a foreign key always unique?

933

---

What is user in sql?

1014

---

How does one use sql*loader to load images, sound clips and documents? : aql loader

1178

---

What is difference between joins and union?

1116

---

What is offset and limit in sql?

1050

---

What is left join example?

940

---

What does joining a thread mean?

1014

---

What are sql built in functions?

933

---

What is a clob in sql?

1011

---

How to get list of all tables from a database?

1148

---

What is group by in sql?

1080

---

Is it possible to pass parameters to triggers?

1097

---

How to create your own reports in sql developer?

1009

---

what is the difference between join and union? : Sql dba

1104

---

What is sql and its types?

1173

---