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
- 6897 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
how to enter characters as hex numbers? : Sql dba
Why do we need cursors in pl sql?
What are the basic sql commands?
what does it mean to have quoted_identifier on? : Sql dba
What are all the different normalizations?
Is sql procedural language?
Is there any restriction on the use of union in embedded sql?
what is a trigger in mysql? : Sql dba
What is trigger and types?
Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?
what is the difference between a web-garden and a web-farm? : Sql dba
What are the different sql commands?
What is sql injection owasp?
What is cost in sql execution plan?
How to install oracle sql developer?
