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 select statement and cursor

Answer Posted / gudekotas

SELECT STATEMENT CONTAINS PARTICULAR STRUCTURE AND SELECT
QUERY RESULT SET CONTAINS ROWID,ROWNUM.

CURSOR DOESN'T CONTAIN STRUCTURE AND IT IS
VIRTUAL(CONTEXAREA)MEANS NO ROWID,NO ROWNUM.

Is This Answer Correct ?    11 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is memory optimized table?

1081


Why is pl sql needed?

1000


What is the difference between instead of trigger and after trigger?

1060


How does an execution block start and end in pl sql?

993


tell me about various levels of constraint. : Sql dba

1070


What are aggregate and scalar functions?

1081


How can you fetch common records from two tables?

1099


Explain the difference between triggers and constraints?

1021


What is dynamic query?

1027


Why stored procedures are faster than query?

1076


when is the use of update_statistics command? : Sql dba

1094


Are sql connections encrypted?

1076


What schema means?

937


What is a dirty read sql?

1233


what is 'mysqlcheck'? : Sql dba

1061