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

State the difference between implict and explict cursor's?

Answer Posted / swapna

Implicit Cursor are declared and used by the oracle
internally. whereas the explicit cursors are declared and
used by the user.

more over implicitly cursors are no need to declare oracle
creates and process and closes autometically. the explicit
cursor should be declared and closed by the user.

More over Explicit Cursors were used to retrieve values
from two or more rows.

Is This Answer Correct ?    28 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Who developed sql?

1089


Are null values same as that of zero or a blank space?

1064


Is it possible to read/write files to-and-from PL/SQL?

1144


What does inner join mean?

1256


What are tables and fields?

1080


What is the use of function "module procedure" in pl/sql?

1233


what is a database transaction? : Sql dba

1253


What are the types of views in sql?

1136


Why do we use sql constraints? Which constraints we can use while creating database in sql?

1080


How can we solve sql error: ora-00904: invalid identifier?

1292


What is the difference between a subquery and a join?

1164


How to pipe multiline string to isql?

1047


what is a relationship and what are they? : Sql dba

1160


Why is sharding used?

1057


Is pl sql still used?

1015