Interested to Buy Any Domain ? << Click Here >> for more details...
I need to write a simple query,which one is better select
statement or stored procedure?and why?
- 2 Answers
- 7022 Views
- iGate, I also Faced
- E-Mail Answers
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 are the benefits of pl/sql packages?
difference between anonymous blocks and sub-programs.
What is the use of procedures?
What is an exception in pl/sql?
In what condition is it good to disable a trigger?
Does truncate remove indexes?
what is the difference between join and union? : Sql dba
What makes a good primary key?
What is package in pl sql?
Is json a nosql?
What is a unique constraint?
Which command is used to call a stored procedure?
what is sql? : Sql dba
What is the difference between jpql and sql?
What is normalization sql?
