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

How to define an anonymous procedure without variables?

1091

Is oracle the best database?

958

What is proxy method?

965

How to delete an existing row from a table in oracle?

1064

Explain how you would restore a database using RMAN to Point in Time?

2136

What is a trigger oracle?

1080

What is the database name in oracle?

1014

Explain self joins in oracle?

1008

What is the Tune Query

2284

Explain the use of file option in exp command.

1122

What is oracle rownum?

945

Name the various constraints used in oracle?

1011

What are the differences between lov and list item?

1058

what are actual and formal parameters?

1102

In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.

1928