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...

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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is group by in sql?

1041


Mention what does plv msg allows you to do?

1075


What is the largest value that can be stored in a byte data field?

976


Explain mutating table error.

1150


Is pl sql and postgresql same?

1075


What is fmtonly in sql?

1022


What is consistency?

1073


What is a join query?

910


How to rename a column in the output of sql query?

1029


What is prepared statement in sql?

1013


What is the use of double ampersand (&&) in sql queries? Give an example

1093


Explain the select statement in sql?

1053


What packages(if any) has oracle provided for use by developers?

5737


Which normal form is best?

909


What is the difference between the implicit and explicit cursors?

1008