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 / akash

Using select..into statement u cannot fetch more than 1 rows.
Beside naming the same select statement as cursor explicitly allows user to options like OPEN,CLOSE,FETCH.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you mean by table in sql?

937


Can you skip header records while loading? : aql loader

972


how does a local variable is defined using t-sql? : Transact sql

947


How to change sql*plus system settings?

995


How do I run sql profiler?

1007


How much does sqlite cost?

984


How can you load multi line records? : aql loader

1019


What is server name sql?

1068


What is a native sql query?

972


Can we debug stored procedure?

956


What is pls_integer in pl sql?

1029


When is a declare statement required?

1080


Explain normalization and what are the advantages of it?

890


What does the argument [or replace] do?

1015


What is sql*loader and what is it used for? : aql loader

1093