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

Is join and inner join the same?

990


What is the function that is used to transfer a pl/sql table log to a database table?

988


What are views in sql?

962


Can pl sql procedure have a return statement?

1001


Does sql profiler affect performance?

976


what is error ora-03113: end-of-file on communication channel?

1149


What is normalisation in sql?

1041


Why do we use procedures in pl sql?

1009


What is having clause in sql?

946


What can sql server reporting services do?

1096


Which is better varchar or nvarchar?

977


What does a pl/sql package consist of?

961


Is there a way to automate sql execution from the command-line, batch job or shell script?

954


What is group function in sql?

1002


What is difference between mysql and postgresql?

1120