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

Why do we use %rowtype & %type in plsql?

1048


Is it possible to include an insert statement on the same table to which the trigger is assigned?

1014


Is sql a dbms?

1011


How would you reference column values before and after you have inserted and deleted triggers?

1065


How many types of normalization are there?

964


what is a materialized view? : Sql dba

1061


What are stuff and replace function?

1081


what are the differences between char and varchar? : Sql dba

1070


How do I run a sql query in pgadmin 4?

961


Can a key be both primary and foreign?

994


GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

3050


What are the different types of tables in sql?

1009


what is a join? : Sql dba

1035


What is pl sql quora?

1160


What if we write return in procedure?

1429