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 ? Why Cursor is required ?

Answer Posted / anil kumar jampana

cursor is a private sql area. pl/sql cann't handle multy
row select statements. Inorder to handle mulyrow select
statements, we are using cursors.

Is This Answer Correct ?    15 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between nvl function, ifnull function, and isnull function?

1153


Why coalesce is used in sql?

1065


What is pragma in pl sql?

1182


What are variables in pl sql?

1228


What are tables and fields in the database?

1184


Name some usages of database trigger?

1081


Which operator is used in query for pattern matching?

1131


How many scalar data types are supported in pl/sql?

1102


what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure

2151


what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

1003


What does pragma mean?

1129


Explain about various levels of constraint.

997


how to create a test table in your mysql server? : Sql dba

1052


1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins

1639


how can I make a script that can be bi-language (supports english, german)? : Sql dba

1063