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

In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??

1657


ABOUT IDENTITY?

2053


What do you mean by a database transaction & what all tcl statements are available in oracle?

992


What is a proxy object?

1061


How to list all user accounts in oracle?

1027


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

1068


What are the different windows events activated at runtime ?

2898


What is recovery manager(rman) backup in Oracle?

1183


Where is the export dump file located?

1147


Can we create database in oracle using command line ?

1085


What is raw datatype?

1136


How a database is related to tablespaces?

1031


Explain oracle insert into command?

1110


What is a sub query? What are its various types?

1176


what's query optimization and without use of IN AND Exist can we get another way data from query

2139