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 usage of merge statement?

1094

Explain user account with reference to oracle.

926

What are the uses of linked server and explain it in detail?

1000

Compare and contrast between sql and sql server and explain its various functions?

916

What is a schema in oracle?

965

Explain the use of full option in exp command.

1054

Explain the different normalization forms?

1008

What is varray?

1034

What is oracle analytical function?

1028

if you ctreate table identity

2313

What happens if recursive calls get out of control?

998

How do I know if oracle is installed on windows?

877

Is it possible to split the print reviewer into more than one region ?

2221

WHAT IS ecc 6.0

2101

What are the types of trigger in oracle?

913