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

Can we use distinct and group by together?

1055

---

How do I kill a query in postgresql?

1121

---

what are the different functions in sorting an array? : Sql dba

1017

---

discuss about myisam key cache. : Sql dba

1021

---

what is innodb? : Sql dba

1102

---

Why left join is used in sql?

979

---

What is the difference between nested table and varray?

1003

---

What are inner and outer joins examples of both?

958

---

Explain the order of sql statement execution?

1045

---

What is offset in sql query?

1112

---

how to use myisamchk to check or repair myisam tables? : Sql dba

970

---

What kind of join is join?

966

---

What is meant by user defined function?

1050

---

Differentiate between sga and pga.

1161

---

What are basic techniques of indexing?

1384

---