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

Difference between varchar and varchar2 data types?

1129

List out the difference between commit, rollback, and savepoint?

997

How to define a cusotmer as a supplier in ORACLE R12

2186

How will you identify oracle database software release?

952

How to define an anonymous procedure with variables?

1077

Explain oracle insert into command?

1066

What is archive log in Oracle?

1078

What is the difference between formal parameters and actual parameters?

1016

How to convert characters to numbers in oracle?

1011

What are triggers in oracle?

982

Can we save images in a database and if yes, how?

1005

Please explain drop constraint oracle?

1032

Can we convert a date to char in oracle and if so, what would be the syntax?

969

In which language oracle has been developed?

1024

What is meant by raw datatype?

1014