Interested to Buy Any Domain ? << Click Here >> for more details...
difference between cursor and procedure in a package
- 3 Answers
- 29643 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
Is it possible to read/write files to-and-from PL/SQL?
Is delete faster than truncate?
What is sqlite format?
Explain the difference between sql and mysql.
What does rownum mean in sql?
what is union? : Sql dba
which operator is used in query for pattern matching? : Sql dba
Why is nosql good?
what is a database transaction? : Sql dba
How do you update sql?
What is sql injection vulnerability?
How many sql are there?
What is mdb stand for?
Why is the cursor important?
How do I start sql from command line?
