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
what is a control file ? : Sql dba
How can we find duplicate records in a table?
What is the sql case statement?
What is the largest value that can be stored in a byte data field?
What is a composite primary key?
What are the types of join in sql?
Can instead of triggers be used to fire once for each statement on a view?
what is the difference between undefined value and null value? : Sql dba
Can we perform dml on view?
What are the ways on commenting in a pl/sql code?
Which certification is best for sql?
What is sql*plus?
what is the difference between cluster and non cluster index? : Sql dba
Is sql a backend language?
What is parallel hint?