Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between a Cursor declared in a procedure
and Cursor declared in a package specification ?
- 2 Answers
- 16272 Views
- JDA, I also Faced
- E-Mail Answers
Answer Posted / ratan singh sengar
SP is a set of SQL Statements that resides in server. Advantage of SP is just that it is pre compiled and available in the server. So, whenever this SP is called, its executed instantly since its already been compiled. This makes the faster performance while executing the SP.
cursor:
Cursors are add on feature of SP , for row by row validations.
For instance : You have a list of employees belong to various department. For calculating the bonus % which varies for department to department, you use cursors to calculate Bonus.
| Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
What language is oracle sql developer?
How does an execution block start and end in pl sql?
What is dense_rank?
how many values can the set function of mysql take? : Sql dba
what is 'mysqlshow'? : Sql dba
how to fetch common records from two tables? : Sql dba
What are sql objects?
Does mysql_real_escape_string prevent sql injection?
How to pronounce postgresql?
What is percent sign in sql?
Write a sql query to get the third highest salary of an employee from employee_table?
Compare sql & pl/sql
How show all rows in sql?
Does pdo prevent sql injection?
Does truncate release storage space?
