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

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

What are triggers in sql?

0 Answers  


What is data type in database?

0 Answers  


Can ddl statements be used in pl/sql?

0 Answers  


What is before trigger?

0 Answers  


What are the different types of database management systems?

0 Answers  






What are the ways on commenting in a pl/sql code?

0 Answers  


If the application is running very slow? At what points you need to go about the database in order to improve the performance?

0 Answers  


How to get the 3rd column(i.e all the data along with the column name)in a table?

2 Answers   Logica CMG,


Why is theta join required?

0 Answers  


How can I delete duplicate rows?

0 Answers  


What is difference between TRUNCATE & DELETE?

16 Answers   Ahn Infotech, CitiGroup, ICICI, PreVator, Saama Tech, SkyTech, TCS,


what is meant by DML?

5 Answers   HCL,


Categories