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...

what is the cursor life span?

Answer Posted / nageswara rao.g

hi friends this is answer as per me,

when static cursor used the cursor lifespan is within
the program only(pl/sql program).its life end when it comes
outside the program
when dynamic cursor is used the cursor is accessable by
outside other programs with in same connection ,not another
connection.i.e its lifespan is with in connection

Is This Answer Correct ?    5 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain activity monitors

1077


How to see the event list of an existing trigger using sys.trigger_events?

1074


Why main is user defined function?

1011


What is normalization and what are the advantages of it?

985


what is raid? : Sql server database administration

1040


What are sql server procedures?

982


How to make conditional sum in ssrs?

177


Why SQL Agent is used?

1150


How is table type constraint applied to a table?

979


What is indexing a document?

1033


Explain about remote stored procedure?

1008


what is unique and xaml nonclustered index

1051


How to grant a permission in ms sql server using "grant execute" statements?

1093


A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?

962


Characterize join and name diverse sorts of joins?

967