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 is a cursor

Answer Posted / t.r.sekhar

cursor is a temporary buffer used to hold the transactional
data for the manipulation purpose.
data will not permanently stored in database.
it is not reusable.

syntax:
cursor <cursor name> is <select stmt);
we have two types of cursors are there.
1.implicit cursors-automatically created whenever dml
statements are executed.
2.explicit cursors-created by user

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which one is faster ienumerable or iqueryable?

864


How to Declare Fixed Length String Value In PL SQL

1101


how to add a new column to an existing table in mysql? : Sql dba

1000


What is aggregate function in sql?

983


How many joins can you have in sql?

880


Can we create table in function?

907


GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

3007


Which is the correct statement about truncate and delete?

1033


How do you remove duplicates without using distinct in sql?

918


What is a temporal table?

879


Can we delete column in sql?

1020


what is try_catch block in procedure

1653


Why is nosql good?

975


What is the usage of when clause in trigger?

988


What is sqlcontext?

981