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

Can we use pl sql in sql server?

1013


What is break?

1141


Can we call procedure in select statement?

976


Can we use pl sql in mysql?

963


Explian rowid, rownum? What are the psoducolumns we have?

945


how to convert dates to character strings? : Sql dba

1072


which types of join is used in sql widely? : Sql dba

930


What is the difference between clustered and non-clustered index in sql?

959


What is the difference between unique and primary key constraints?

1010


How do you update sql?

915


what is an alias command? : Sql dba

1011


How can you load microsoft excel data into oracle? : aql loader

1130


How can a function retun more than one value in oracle with proper example?

1029


How does sql developer connect to oracle database?

950


What is right join in sql?

1023