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 difference between cursor and ref cursor?



What is difference between cursor and ref cursor?..

Answer / kiran r

Cursor is is pointer which is used access data retrived from database.Cursor is static in nature

ref cursor is datatype variable. whose memory address is working area query in database. it is dynamic in nature and it can be modified at the runtime

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

What is pl sql architecture?

0 Answers  


Explain 3 basic parts of a trigger.

0 Answers  


What is sqlexception in java?

0 Answers  


How to add, remove, modify users using sql?

0 Answers  


what are the tunnig tables you used for tuning a query and tell me some of coloumns in that tuning tables?

1 Answers   Metric Stream,


how do you know if your mysql server is alive? : Sql dba

0 Answers  


What is the syntax to add a record to a table?

0 Answers  


i have a table with fields(id,name,accnt_type)and in account type are FD,SAVING,RD. Write a query to get How many number of People are in each type of Account?

6 Answers   Fidelity, IBM,


What is Function based Index and which type of function we can use in Function base index. can we use aggregate,NVL function in Function based Index..

1 Answers   Metric Stream, Polaris,


Is sql an operating system?

0 Answers  


How to create a menu in sqlplus or pl/sql?

0 Answers  


What has stored procedures in sql?

0 Answers  


Categories