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

How to return an array from java to pl/sql?

1061


Is sql similar to python?

917


How do sql triggers work?

987


What is rownum?

923


what is not null constraint? : Sql dba

964


Is full outer join same as cross join?

913


What are the steps for performance tuning.

1268


Difference between table function and pipelined function?

967


Mention what is the function that is used to transfer a pl/sql table log to a database table?

932


What is difference between pls_integer and integer?

908


What is a schema sql?

1053


What is structural independence and why is it important?

978


What is the difference between join and natural join?

881


What is the difference between database trigger and stored procedure?

1007


What is primary key secondary key alternate key candidate key?

980