in procedure one time compilation is done,whereas in query compilation is

Difference between a query and strored procedure?

Question Posted / khushbu wadhwani

Answer Posted / khushbu wadhwani

in procedure one time compilation is done,whereas in query
compilation is done everytime.so,procedure improves
efficiency & performance

Is This Answer Correct ?

3 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How do I run pl sql in sql developer?

1059

What are the different types of dbms?

954

What are the different schemas objects that can be created using pl/sql?

967

Can we insert in sql function?

1025

What is t sql used for?

972

What are the most important ddl statements in sql?

1024

What is prepared statement in sql?

993

Does a user_objects view have an entry for a trigger?

959

Can we use views in stored procedure?

968

What is compiled query?

954

Is big data nosql?

886

When you have to use a default "rollback to" savepoint of plvlog?

1123

What is a memo field?

900

What is the importance of sqlcode and sqlerrm?

1277

What is a ddl command?

1006