Interested to Buy Any Domain ? << Click Here >> for more details...
What is the different between Stored Procedure and Procedure?
- 7 Answers
- 14414 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
What is relationship? How many types of relationship are there?
What does bitemporal mean?
What is not null in sql?
What are transaction and its controls?
What are few of the schema objects that are created using PL/SQL?
How do I run a script in sql developer?
What is trigger in sql and its types?
How to start oracle sql developer?
What is the requirement of self-join?
What is a primary key example?
What are hotfixes and patches?
Is it possible to include an insert statement on the same table to which the trigger is assigned?
What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql
What is a native sql query?
What is oracle pl sql developer?
