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
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 |
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 |
What are triggers in sql?
What is data type in database?
Can ddl statements be used in pl/sql?
What is before trigger?
What are the different types of database management systems?
What are the ways on commenting in a pl/sql code?
If the application is running very slow? At what points you need to go about the database in order to improve the performance?
How to get the 3rd column(i.e all the data along with the column name)in a table?
Why is theta join required?
How can I delete duplicate rows?
What is difference between TRUNCATE & DELETE?
16 Answers Ahn Infotech, CitiGroup, ICICI, PreVator, Saama Tech, SkyTech, TCS,
what is meant by DML?