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

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

what are the advantages of cursors than procedures?

Question Posted / swapna

Answers were Sorted based on User's Feedback



what are the advantages of cursors than procedures?..

Answer / kumar srinivasalu

Cursors can be used to pass the parameters to procedures
and functions. The Single cursor used to multiple
updatation and used multiple queries at run time

Is This Answer Correct ?    16 Yes 0 No

what are the advantages of cursors than procedures?..

Answer / 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

More SQL PLSQL Interview Questions

What is synchronized subquery?

0 Answers  

Why you are not able to create a table using select command,if it is having a LONG column? for eg:create table test as select * from test1 here test1 containg a column having LONG datatype...

1 Answers  

What is auto increment feature in sql?

0 Answers  

Regarding joins what are the differences you observed in oracle 9i and sql server?

3 Answers   Choice Solutions,

How can you load multi line records? : aql loader

0 Answers  

How to convert ms-excel file to oracle table?

2 Answers  

Define concurrency control. : Transact sql

0 Answers  

what is a cursor

9 Answers   IBM, TCS, Wipro,

What are the different datatypes available in PL/SQL?

0 Answers  

Authentication mechanisms in Sql Server ?

1 Answers   BirlaSoft,

What does sign mean sql?

0 Answers  

How much ram can sql express use?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories