What is the different between Stored Procedure and Procedure?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / k.deepthi
Yes,Store Procedure/Procedure are one and the same.We have
to Create Procedure and Compile it in Data base,once
compiled it will be stored and we can use the same when
ever required in various other Procedures.
Procedure Usually used to perform set of actions based on
conditions.
Is This Answer Correct ? | 5 Yes | 2 No |
Answer / roshan kumar
Procedure-
A procedure is a specified series of actions,acts or operations which have to be executed in the same mannner in order to always obtain the same result under the same circumstances.
Stored Procedure-
A stored procedure is a subroutine available to applicATIONS accessing a Relational database system.stored procedures(sometimes called as proc,sproc or sp) are actually stored in database dictionary.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / v.v.s.vamshi krishna
In Procedures we give the functions and parameters to be
used instantly. this scenario goes similar to that of
instant food. This happens when the complexity is less. But
as far as the stored procedures are concerned they provide
much reusability and can complexity can be handled with
much ease.
Is This Answer Correct ? | 2 Yes | 3 No |
Answer / pramod janjirala
Two are same.Once the procedure is created and compiled ,it
is stored in database permanently.That's why it is called as
stored procedure.
Is This Answer Correct ? | 6 Yes | 8 No |
Answer / rasmita basantia
if we are writing a procedure with create or replace
syntax ,then its a procedure.if its compiled and stored in
the data base then its called stored procedure.
Is This Answer Correct ? | 1 Yes | 5 No |
How many postgresql users are there, worldwide?
one of the column in my table contains the data like SAL ---- 1000 1000 2000 3000 3000 So my requirement is i want output like SAL --- 1000 2000 3000 it mean i want to delete duplicate rows in the table permanently and i want output in the above formatow should u write query?
in sql table follw columns r their vehicle_no|servicetype|date|location| 1234 |1FS |1-JAN|PUNE| 4561 |2FS |5-JAN|PUNE| 1234 |PS |7-JAN|PUNE| 1234 |PS |15-JAN|MUMB| i want o/p below vehicleno|1fs|1fsdate|1fslocation|1ps|1PSDATE|1PSLOC|2PS|2PS DATE|2PSLOCA e.g 1234|1FS|1JAN|PUNE|1PS|7JAN|PUNE|2PS|15JAN|MUMBAI PLS help me out to execute using sql query
How does one use sql*loader to load images, sound clips and documents? : aql loader
what happens if you no create privilege in a database? : Sql dba
When is the update_statistics command used?
What is the main difference between a UNION statement and a UNION ALL statement? 1. A UNION statement eliminates duplicate rows; a UNION ALL statement includes duplicate rows. 2. A UNION statement can be used to combine any number of queries; a UNION ALL statement can be used to combine a maximum of two queries. 3. A UNION statement can only combine queries that have parallel fields in the SELECT list; a UNION ALL statement can combine queries with differing SELECT list structures. 4. A UNION statement cannot be used with aggregate functions; a UNION ALL statement can be used with aggregate functions. 5. There is no difference between the two statements; they are interchangeable.
what is the forward decleration in packages?
What is the use of triggers?
What are the different type of joins in sql?
explain commit and rollback in mysql : sql dba
What is union, minus and interact commands?