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


Please Help Members By Posting Answers For Below Questions

What is bitemporal narrowing?

739


What is date functions?

577


What is execution plan in sql?

552


Why stored procedures are faster than query?

570


Can we insert delete data in view?

548






Can a key be both primary and foreign?

510


Show the cursor attributes of pl/sql.

615


What will you get by the cursor attribute sql%rowcount?

554


Can we create index on primary key?

524


what is the difference between delete and truncate statement in sql? : Sql dba

555


What port does sql server use?

512


Explain the difference in execution of triggers and stored procedures?

573


is it possible to pass an object or table to a procedure as an argument?

576


How do you clear the screen in sql?

609


What are variables in pl sql?

569