difference between cursor and procedure in a package

Answers were Sorted based on User's Feedback



difference between cursor and procedure in a package..

Answer / avi007

cursor-
1 cursor is small memory area to perform selection on the
one or more table.
2 cursor is a variable which is 2 dimentional array, it is
handling, storing and processin multiple rows.
3 storing data temporarily.
4 fetching rows from top to bottom.
5 fetching row one at a time.

procedure -
1 procedure is an object of database.
2 need to compile and execute.
3 dml operation performed in the block.

Is This Answer Correct ?    33 Yes 5 No

difference between cursor and procedure in a package..

Answer / 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

difference between cursor and procedure in a package..

Answer / a.jyothsna

Cursors in package should have a return type
Whereas for the procedures it's not required

Is This Answer Correct ?    13 Yes 12 No

Post New Answer

More SQL PLSQL Interview Questions

Is it possible to use Transaction control Statements such a ROLLBACK or COMMIT in Database Trigger ? Why ?

5 Answers  


How can you save or place your msg in a table?

0 Answers  


What is mutating error?

0 Answers  


What is the difference between null value, zero, and blank space?

0 Answers  


How do I run a sql query?

0 Answers  






Which kind of parameters cannot have a default value in pl sql?

0 Answers  


List the different type of joins?

0 Answers  


Why do we use sql constraints? Which constraints we can use while creating database in sql?

0 Answers  


how will be date change into string

4 Answers  


What is foreign key sql?

0 Answers  


What if we write return in procedure?

0 Answers  


What is a cursor ? Why Cursor is required ?

3 Answers  


Categories