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

difference between imlicit cursor and explicit cursor ?

Answer Posted / vipin kumar ( m.c.a)

1. Implicit cursor:- means predefine cursor. Its attributes
starting with the sign % like that %ROWCOUNT, %ISOPEN etc.
2. Explicit cursor:- means created by the user or
programmer. Its attributes starting with the cursor name
then % sign lick that cursorname%ROWCOUNT, cursorname%ISOPEN
etc.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the quickest way to fetch the data from a table?

1014


What do you mean by cdb and pdb in oracle 12c?

1023


How to load a large xml file?

1013


How to retrieve data from an cursor to a record?

1043


How to export data to a csv file?

1235


What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

2006


How to define a record variable to store a table row?

1025


What are the logical operations?

1076


How do I limit the number of oracle database connections generated by weblogic server?

1020


Can objects of the same schema reside in different tablespace?

1017


What is backup in Oracle?

966


In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col

4128


How to install oracle database 10g xe?

977


From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.

1030


Is there a function to split a string in plsql?

1002