Difference between a query and strored procedure?

Answer Posted / tathagoto

query will be compiled each time excution
stored procedure will be compiled once and after that it
will execute when it will be called....

Is This Answer Correct ?    12 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many sql core licenses do I need?

603


What are keys in sql?

621


what is the difference between inner and outer join? Explain with example. : Sql dba

636


Why triggers are used?

648


Explain character-manipulation functions?

731






What does truncate mean in sql?

631


Is sql between inclusive?

702


What are the types of variables use in pl sql?

600


How do you optimize a stored procedure query?

653


Differentiate between syntax and runtime errors.

739


What is java sql connection?

601


What is execute immediate?

634


what are all the common sql function? : Sql dba

677


explain access control lists. : Sql dba

633


What is latest version of sql?

615