difference between cursor and procedure in a package
- 3 Answers
- 28636 Views
- PCS, I also Faced
- E-Mail Answers
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 This Answer Correct ? | 24 Yes | 9 No |
Post New Answer View All Answers
How to use transactions efficiently : transact sql
what is a scheduled jobs or what is a scheduled tasks? : Sql dba
How do you remove duplicate records from a table?
What is the use of pl/sql table?
Is primary key is clustered index?
What is the difference between the conventional and direct path loader? : aql loader
How are sql commands classified?
Can procedure in package be overloaded?
What are dml commands?
What is pl sql commands?
What is lexical units in pl sql?
What is meant by cursor in sql?
What does the argument [or replace] do?
If the application is running very slow? At what points you need to go about the database in order to improve the performance?
What is pl sql and why it is used for?
