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 >> Oracle >> Oracle General
  2. Suggest New Category

How you open and close a cursor variable.Why it is required?

Question Posted / nishi

Answer Posted / nishi

OPEN cursor variable FOR SELECT...Statement

CLOSE cursor variable In order to associate a cursor variable with a particular SELECT statement OPEN syntax is used. In order to free the resources used for the query CLOSE statement is used.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Give the various rollback segment states.

1052

Explain oracle 12c new features for developers?

1058

What are group functions in oracle?

1041

Why do we need integrity constraints in a database?

1020

Query to retrieve record for a many to many relationship ?

2519

How do I manually create a database in oracle?

1019

If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...

2231

Difference between inner join vs where ?

1033

How to connect to a remote server?

1125

How to download oracle database 10g xe?

1018

What is clustered table in Oracle?

1196

How to load data through external tables?

1135

How to get a create statement for an existing table?

969

What is a partition in oracle?

1122

What happens to the current transaction if a ddl statement is executed?

1013