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

Which is better varchar or nvarchar?

933

---

What is rowid in sql?

906

---

How do you exit in sql?

1062

---

Does view contain data?

983

---

how to return query output in html format? : Sql dba

1021

---

Is ms sql traffic encrypted?

871

---

What is a pragma statement?

1201

---

What are the types of optimization?

887

---

What is the meaning of disabling a trigger?

1111

---

What is the primary key?

877

---

How do I delete a trigger?

912

---

What is difference sql and mysql?

939

---

What is difference between sql and excel?

1006

---

How many types of tables are there?

900

---

What does over partition by mean in sql?

919

---