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

I need to write a simple query,which one is better select
statement or stored procedure?and why?

Question Posted / sujeethkumar

Answers were Sorted based on User's Feedback



I need to write a simple query,which one is better select statement or stored procedure?and why?..

Answer / sudipta santra

A simple query because through query we can throw the result
of the data based on conditions but in stored procedure we
can not , as the procedure is used for the specific time
based for the specific value return through out/IN out .

A simple query is best. But it is wrong that we can not do
through a proc, we can do but the effort will take more.

Is This Answer Correct ?    5 Yes 1 No

I need to write a simple query,which one is better select statement or stored procedure?and why?..

Answer / john

simple query s best as we can issue query by giving various
condition and it will not get stored in database where as a
procedure will get stored in database and gotta occupy
memory.so its waste of memory and time to create a
procedure rather than issuing a si9ngle query

Is This Answer Correct ?    4 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

how many tupples can insert in 1 second in sql

1 Answers  

What is the use of index in sql?

0 Answers  

What are the different types of joins and explain them briefly.

3 Answers  

Explain how procedures and functions are called in a PL/SQL block ?

3 Answers  

Write a query to get 2nd maximum salary in an employee table ?

69 Answers   Accenture, BirlaSoft, Letse, Logica CMG, Qwest, Rheal Software, Saagam, Semantic Space, Tailor Solution, TCS, TinyERP,

Explain isolation levels. : Transact sql

0 Answers  

How write primary and foreign key relationship between two tables without using constraints? u can use any of procedure/function/trigger and any sql?

1 Answers   Parexel,

What are Global Temporary tables

3 Answers   IBM, TCS,

What is dense_rank in sql?

0 Answers  

What are hotfixes and patches?

0 Answers  

Can you have more than one trigger on a table?

0 Answers  

how can we know the number of days between two given dates using mysql? : Sql dba

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories