Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

What is difference between a Cursor declared in a procedure
and Cursor declared in a package specification ?

Question Posted / guest

Answers were Sorted based on User's Feedback



What is difference between a Cursor declared in a procedure and Cursor declared in a package specif..

Answer / tulsi

A cursor declared in a package specification is global and
can be accessed by other procedures or procedures in a
package.
A cursor declared in a procedure is local to the procedure
that can not be accessed by other procedures.

Is This Answer Correct ?    40 Yes 2 No

What is difference between a Cursor declared in a procedure and Cursor declared in a package specif..

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

More SQL PLSQL Interview Questions

What is normalization in sql?

0 Answers  

what is the use of set statement in tsql? : Transact sql

0 Answers  

in materialized view the structure will create immediately or not?

2 Answers   iFlex,

Do you know the basic structure of PL/SQL?

3 Answers  

How to change sql*plus system settings?

0 Answers  

which command using query analyzer will give you the version of sql server and operating system? : Sql dba

0 Answers  

What is procedure and function?

0 Answers  

how to install mysql? : Sql dba

0 Answers  

What is a call statement? Explain with an example.

0 Answers  

What is a mutating table and a constraining table?

0 Answers  

What is meant by cursor in sql?

0 Answers  

what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories