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

Types of cursors and explanation each of them ?

Answer Posted / sohail

Cursor is a pointer or handler to context area.there are
three types if cursors
1.implicit cursor: Every SQL statment between begin and end
are implicit cursors.
2.explicit cursor:As a name user has to explicitly
create,open and close cursors.
3. ref cursor: Reference cursor is a datatype which holds
the value of a cursor.

Is This Answer Correct ?    8 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Do we need to create index on primary key?

852


Why truncate is faster than delete?

1052


List the different type of joins?

1000


What is a sql schema used for?

1027


What are pl/sql cursors?

989


what are different types of collation sensitivity? : Sql dba

1021


Explain the uses of a database trigger?

981


How do I remove sql plus from windows 10?

1023


how to get @@error and @@rowcount at the same time? : Sql dba

967


Can we use pl sql in mysql?

959


Which function is used to return remainder in a division operator in sql?

1073


What are the two types of periodical indexes?

886


What's the procedure?

865


Is like operator in sql case sensitive?

960


Can you skip header records while loading? : aql loader

972