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.

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.

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.

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.

Answer / abhishek

Stored procedure is a subprogram in oracle and procedure is an anoyomous block. Stored procedure can be caled by exec at any time wen the user require it for execution..Procedure are created for temporary execution and they are not stored

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.

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.

How to place comments in pl/sql?

0 Answers  

Hi all, i have a table as follows empid empname mgrid deptid 1 a 3 4 2 b 1 5 3 c 2 3 4 d 3 6 5 e 4 7 i want the output as empname mgrname a c b a c b d c e d

4 Answers  

i want insert 10 records from table a to table b. if i m using statement level trigger how many record insert ?in row level trigger how many record inserted???

3 Answers   Scope International,

i have a table like this. i want to output like this c1 c2 c1 c2 1 10 1 10 2 20 2 30 3 30 3 60 4 40 4 100 5 5 5 105 c1 and c2 are columns in a table .i want output like this c2 values are 10,10+20,10+20+30,10+20+30+40.10+20+30+40+5. write a sql query.pls help this i want urgent.

2 Answers   IBM, Loginworks, OFSS,

What is sql catalog?

0 Answers  

What are sql procedures?

0 Answers  

What is the difference between an inner join and an outer join?

0 Answers  

what is the sql query to display current date? : Sql dba

1 Answers  

How do I count rows in sql query?

0 Answers  

check whether all the emp numbers are indeed unique.

6 Answers  

How do you concatenate in sql?

0 Answers  

What is correlated sub-query?

7 Answers   Oracle,