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

why use cursors?

Answer Posted / suresh kumar somayajula

Cursor : It's a private SQL worksheet area where we can
execute SQL commands and processing information.
The purpose of the Cursor is, PL/SQL execution block will
process only one records means it will return only one
records.If we want to retrieve or process more number of
records we use the "Cursors".
These are of two types.
1. Implicit Cursor 2. Explicit cursors.

Thank you,
Suresh

Is This Answer Correct ?    30 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are database links used for?

990


Why we use joins in sql?

924


what is view? : Sql dba

912


explain access control lists. : Sql dba

946


How can you load microsoft excel data into oracle? : aql loader

1128


What is clustered and nonclustered index in sql?

893


How can I tell if sql is running?

992


Where is sql database stored?

919


Why is sql*loader direct path so fast?

1053


Which normal form is best?

895


List and explain the different types of join clauses supported in ansi-standard sql?

1300


Do we need to create index on primary key?

853


What is sql partition function?

1116


How many developers work on postgresql?

915


What is function and procedure?

984