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...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

Difference between a query and strored procedure?

Question Posted / geethu

Answers were Sorted based on User's Feedback



Difference between a query and strored procedure?..

Answer / tathagoto

query will be compiled each time excution
stored procedure will be compiled once and after that it
will execute when it will be called....

Is This Answer Correct ?    12 Yes 0 No

Difference between a query and strored procedure?..

Answer / srao

Query is nothing but a single statement to retrieve data
from one or more tables.

Procedure is nothing but the combinations of Different
queries.

Is This Answer Correct ?    8 Yes 4 No

Difference between a query and strored procedure?..

Answer / khushbu wadhwani

in procedure one time compilation is done,whereas in query
compilation is done everytime.so,procedure improves
efficiency & performance

Is This Answer Correct ?    3 Yes 0 No

Difference between a query and strored procedure?..

Answer / r.s.chauhan

Sp gets stored at the server side where as Not necessary
for query(It can be from application or Clint(sql oem) etc)

Is This Answer Correct ?    2 Yes 3 No

Post New Answer

More SQL PLSQL Interview Questions

what is the difference between myisam static and myisam dynamic? : Sql dba

0 Answers  

What are all ddl commands?

0 Answers  

How to get each name only once from an employee table?

0 Answers  

Write a query to find the names of users that begin with "um" in sql?

0 Answers  

source destination distance chennai bangalore 500 bangalore chennai 500 hyd delhi 1000 delhi hyd 1000 bangalore hyd 800 Here chennai to bangalore and bangalore to chennai is same distance. and hyd and delhi also same criteria. Based on the distance i want to display only one row using sql query?

4 Answers   JPMorgan Chase,

What is intersect?

1 Answers  

What are different joins used in sql?

0 Answers  

Can we edit a view in sql?

0 Answers  

what is top in tsql? : Transact sql

0 Answers  

Can we use pl sql in sql server?

0 Answers  

What is different between union and minus?

7 Answers   Accenture, TCS,

What is the life of an sql statement?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories