query will be compiled each time excution stored procedure will be compile

Difference between a query and strored procedure?

Question Posted / tathagoto

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

Please Help Members By Posting Answers For Below Questions

Is oracle sql free?

926

What are the indexing methods?

1001

What are tables in sql?

996

How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000

2107

Why use triggers in sql?

890

Why do we use view in sql?

905

How do you remove duplicates without using distinct in sql?

918

What is the use of function in sql?

1026

What is sql query optimization?

1018

What is trigger price?

921

What are the basic sql commands?

1036

How to get help at the sql prompt?

1052

What is pl sql architecture?

919

What is a database trigger?

1016

Which are the different types of indexes in sql?

990