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 is the use of cursor ? how cursor allocate context area for executing the sql statement?

Question Posted / sowmya

Answer Posted / sowmya

Hi
cursors allow row -by-row processing of the resultsets
Types of cursors are: static,dynamic,
forward-only,keyset-driven,

disadvantages of cursors are : each time you fetch a row
from the cursor,it results in a network roundtrip,where are
as normal select query makes only one round trip
cursors are costly as they need temparory storage.

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to install oracle sql developer?

996

What is sql profiling in oracle?

1010

Why do we use procedures?

921

How do you update sql?

922

How do I count records in sql?

953

How do I remove sql developer from windows 10?

1028

What is rename in sql?

923

Describe different types of general function used in sql?

987

what is row? : Sql dba

1178

what is bdb (berkeleydb)? : Sql dba

982

What is function and procedure?

990

What are stuff and replace function?

1024

Define SQL and state the differences between SQL and other conventional programming Languages?

1158

How many joins can you have in sql?

888

How to download oracle sql developer?

1062