difference between cursor and procedure in a package
- 3 Answers
- 28643 Views
- PCS, I also Faced
- E-Mail Answers
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 indexing oracle sql?
What is recursive stored procedure?
What are the set operators in sql?
How many triggers can be applied on a table?
what is the difference between union and union all? : Sql dba
What are triggers and its uses?
How can I speed up sql query?
What is the difference between a database and a relational database?
Define select, insert, create, delete, update, drop keywords
Explain the working of foreign key?
How many databases can sql express handle?
What is scalar function in sql?
what is the difference between clustered and non clustered index in sql? : Sql dba
What are the syntax and use of the coalesce function?
What does select * from mean in sql?
