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
What is triggering circuit?
Is pl sql and postgresql same?
How do I run pl sql in sql developer?
What is the purpose of the sql select top clause?
What is a join query?
what does myisamchk do? : Sql dba
How do you clear the screen in sql?
What is cross join example?
What is #table in sql?
What is the best sql course?
what are null values? : Sql dba
What operating systems are supported by oracle sql developer?
Describe sql comments?
What are different sql data types?
How delete all data from all tables in sql?