difference between cursor and procedure in a package

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is triggering circuit?

590


Is pl sql and postgresql same?

563


How do I run pl sql in sql developer?

621


What is the purpose of the sql select top clause?

544


What is a join query?

544






what does myisamchk do? : Sql dba

552


How do you clear the screen in sql?

595


What is cross join example?

544


What is #table in sql?

515


What is the best sql course?

526


what are null values? : Sql dba

538


What operating systems are supported by oracle sql developer?

515


Describe sql comments?

552


What are different sql data types?

504


How delete all data from all tables in sql?

532