Difference between a query and strored procedure?
Answer Posted / srao
Query is nothing but a single statement to retrieve data
from one or more tables.
Procedure is nothing but the combinations of Different
queries.
Is This Answer Correct ? | 8 Yes | 4 No |
Post New Answer View All Answers
What is bitemporal narrowing?
What is date functions?
What is execution plan in sql?
Why stored procedures are faster than query?
Can we insert delete data in view?
Can a key be both primary and foreign?
Show the cursor attributes of pl/sql.
What will you get by the cursor attribute sql%rowcount?
Can we create index on primary key?
what is the difference between delete and truncate statement in sql? : Sql dba
What port does sql server use?
Explain the difference in execution of triggers and stored procedures?
is it possible to pass an object or table to a procedure as an argument?
How do you clear the screen in sql?
What are variables in pl sql?