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?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the use of count (*) in sql?

1051


How subquery works in sql?

1067


What is pl sql block structure?

1034


What is nvarchar max in sql?

1011


Explain unique key in sql.

1007


Mention what does the hierarchical profiler does?

1088


What are the different types of triggers?

1131


What is the purpose of a sql?

974


Define select, insert, create, delete, update, drop keywords

1044


What is difference between table and view?

1048


How do you break a loop in pl sql?

1045


Can we group by two columns in sql?

990


What is the use of index in hive?

1003


How do I find duplicates in two columns?

1162


What is the difference between a subquery and a join?

1099