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 are the different types of cursors? explain?

Answer Posted / srilakshmi paleti

1)Implicit cursor
2)Explicit Cursor

EXPLANATION OF
1)IMPLICIT CURSOR : When ever user performs any DML
operation automatically implicit cursors will raise. User
noneed to create,open,fetch,close the cursor.In PLSQL
select statement also it will work.

2)EXPLICIT CURSOR: User has to create,open,fetch and close
the cursor.

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to drop an index?

907


What happens to the data files if a tablespace is dropped?

994


What is the difference between online and offline backups?

971


How do we get field details of a table?

932


What is a read write transaction in oracle?

1031


How to convert dates to characters in oracle?

983


What is the scope of a local variable?

995


can anyody please send me the dump for Oracle 10g certifications for DBA path?

2088


Please explain drop constraint oracle?

1026


How do I use unicode codesets with the weblogic jdriver for oracle driver?

1013


How to delete a user account in oracle?

912


What language does oracle use?

1046


List the various oracle database objects?

994


Why is oracle used?

879


How to define a data source name (dsn) in odbc manager?

965