Interested to Buy Any Domain ? << Click Here >> for more details...
What is the different between Stored Procedure and Procedure?
- 7 Answers
- 14365 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 the difference between union and union all? : Sql dba
What can sql server reporting services do?
List the various privileges that a user can grant to another user?
Why do we use subquery?
What is the difference between execution of triggers and stored procedures?
tell me about various levels of constraint. : Sql dba
Write a sql query to get the third highest salary of an employee from employee_table?
Do triggers have restrictions on the usage of large datatypes, such as long and long raw?
How delete all records from table in sql?
What is an index? What are the types of indexes? How many clustered indexes can be created on a table?
Is sql free?
Is left join same as inner join?
Why trigger is used in sql?
How does join work in sql?
How can I delete duplicate rows?
