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

What is cold data?

1007

---

What is nosql db?

1010

---

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

1224

---

Is sql an operating system?

1069

---

Does asenumerable execute the query?

1093

---

1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...

2495

---

What is where clause in sql?

1084

---

what are the advantages of sql ? : Sql dba

1105

---

How do you change a value in sql?

1062

---

Define commit?

1049

---

How can I speed up sql query?

1003

---

What do you know by pl/sql cursors?

1161

---

explain the advantages and disadvantages of stored procedure? : Sql dba

1059

---

When you have to use a default "rollback to" savepoint of plvlog?

1248

---

Is natural join same as inner join?

982

---