What is the different between Stored Procedure and Procedure?
Answer Posted / sachin fulari
In Layman tounge -
---------------
Whenever any named block in PL/SQL is created using CREATE
OR REPLACE clause, and as we compile it will get stored in
database, henceforth other code snippets can call/use this
block which ulimately resides in database after creation
i.e. "stored in database". And thus will move along
database if ever we move the database.
In oracle way -
---------------
A stored procedure is created and stored in the database as
a schema object. Once created and compiled, it is a named
object that can be run without recompiling. Additionally,
dependency information is stored in the data dictionary to
guarantee the validity of each stored procedure.
Is This Answer Correct ? | 15 Yes | 1 No |
Post New Answer View All Answers
Why is sharding used?
What is an inconsistent dependency?
What is difference between hql and sql?
How do you concatenate in sql?
What is pl sql and why it is used for?
How do you declare a user-defined exception?
Does execute immediate commit?
What is a primary key? Explain
What is a table?
what are all different types of collation sensitivity? : Sql dba
What is union and union all keyword in sql and what are their differences?
What is trigger and stored procedure in sql?
How to write pl sql program in mysql command prompt?
How does sql store data?
What is pl/sql table? Why is it used?