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 advantages of cursors than procedures?

Answer Posted / somashekhar m

By using cursors It is possible to fetch row by row, when
user might want to work with rows one at a time. But not
possible with SQL standard statements it is not possible to
go row by row fetching.
A cursor can be defined as is a set of rows together with a
pointer that identifies a current row.

in ACID cursor works for consistency of the data.

Is This Answer Correct ?    12 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is blind sql injection?

1071


What is the cause of mutating table error and how can we solve it?

1048


How does postgresql compare to "nosql"?

1029


What is user in sql?

1019


Can two tables have same primary key?

976


What is the purpose of primary key?

1026


how to select first 5 records from a table? : Sql dba

977


what is isam? : Sql dba

1004


How do you get column names only for a table (sql server)?

1161


Compare sql & pl/sql

1137


What is the use of <> sql?

980


what is a constraint? : Sql dba

1166


What is sql key?

989


Is sql between inclusive?

1128


What is a full join?

982