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 scalar function?

1002


What is online transaction processing (oltp)?

962


How can we make an if statement within a select statement?

959


What is data abstraction in sql?

968


What is blind sql injection?

992


What are the built in functions of sql?

983


what is data integrity? : Sql dba

988


Which command is used to delete a package?

1092


What is the main difference between sql and pl/sql?

1028


Explain the difference between sql and mysql.

1003


How much does sqlite cost?

986


What is sqlcommand?

965


Write the alter statement to enable all the triggers on the t.students table.

1069


What is the difference between rename and alias?

1270


What is set serveroutput on?

1088