I need to write a simple query,which one is better select
statement or stored procedure?and why?
Answer Posted / 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 |
Post New Answer View All Answers
What is serial sql?
How do I start sql from command line?
What are the ddl commands?
how would you get the current date in mysql? : Sql dba
What is row_number () in sql?
how to create a table index in mysql? : Sql dba
Is oracel sql developer written in java?
What is the reports view in oracle sql developer?
What is an ndf file?
What is sql keyword?
What is the difference between explicit and implicit cursors in oracle?
What is integrity in sql?
Is it possible for a table to have more than one foreign key?
Explain what is a column in a table?
Is sql better than excel?