What is the different between Stored Procedure and Procedure?
- 7 Answers
- 13054 Views
- Informatica, MIS, I also Faced
- E-Mail Answers
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
difference between anonymous blocks and sub-programs.
how to convert dates to character strings? : Sql dba
What is the difference between drop and truncate commands?
Explain the rollback statement?
What is the most restrictive isolation level? : Transact sql
What is sql engine in oracle?
Can we join tables without foreign key?
What is asqueryable?
What is aggregate function in sql?
What is the difference between union and union all command?
How much does sql certification cost?
How to use sql statements in pl/sql?
Can we use distinct and group by together?
Why do we need view in sql?
Which kind of parameters cannot have a default value in pl sql?
