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

What is the difference between view and materialized view in Oracle?

1200

What is the use of oracle?

1075

What is flashback in Oracle?

1058

What is a named program unit?

1131

What is coalesce function?

1135

Can we connect to ORACLE db using Windows Authentication?

1303

various types of hints and their usage

2743

Explain an extent?

1150

Explain enable novalidate constraint.

1129

What is set verify off in oracle?

1153

What is the difference between "as" and "is" in an oracle stored procedure?

1044

Why does oracle 9i treat an empty string as null?

1122

How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?

2868

How to use select statement to count the number of rows in oracle?

1090

Explain the use of Merge statement in oracle 11g

1072