Interested to Buy Any Domain ? << Click Here >> for more details...
difference between cursor and procedure in a package
- 3 Answers
- 29648 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
1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins
What are sql functions? Describe in brief different types of sql functions?
What is a pdo connection?
What is compute?
Does truncate need commit?
explain advantages of myisam over innodb? : Sql dba
How can the performance of a trigger be improved?
what is “go” in t-sql? : Transact sql
Is there a 64 bit version of ssms?
Mention what does plv msg allows you to do?
What are different types of sql?
What are the three forms of normalization?
Explain what is a view?
Why are indexes and views important to an organization?
How do you explain an index number?
