Answer / rajesh

stored procedure is a named pl/sql block which accept some
parameter and performs some action....and its a one time
compilation....

Answer / 6/8/07

It is named pl/sql block that can accept parameters to
perform an action and is stored in database is called
stored procedure

Answer / charumathi

Store Procedure is named PL-SQL block stored in oracle
server when loaded into memory while execution.
A stored procedure is -a named group of SQL statements
-that have been previously created
and stored in the server database.
-Stored procedures accept input
parameters so that a single procedure can be used over the
network by several clients using different input
data.
-Stored procedures reduce network
traffic and improve performance. Additionally, stored
procedures can be used to help ensure the integrity of the
database.

Answer / rajeev

NAMED PL/SQL BLOCK STORED IN ORCALE SERVER , CAN ACCEPT
PARAMETERS AND CAN BE INVOKED REPEATDLY BY NAME .

Answer / uday

Sp is nothing but Group of T-Sql Statments compiled into a
single execution plan.

Sy: create procedure Pname

{@parameter1 datatype,@parameter2.........)
as

SQL Statments

end

Plz let me know if i am wrong
uday_testing@yahoo.co.in

Answer / nashiinformaticssolutions

A stored procedure is a precompiled block of PL/SQL code stored in the database, which can be executed to perform a specific task.
Syntax Example:
CREATE OR REPLACE PROCEDURE IncreaseSalary(emp_id NUMBER, increment NUMBER) AS
BEGIN
UPDATE employees
SET salary = salary + increment
WHERE id = emp_id;
END;
To execute:
EXEC IncreaseSalary(101, 500);

Answer / glibwaresoftsolutions

A stored procedure is a precompiled block of PL/SQL code stored in the database, which can be executed to perform a specific task.
Syntax Example:
CREATE OR REPLACE PROCEDURE IncreaseSalary(emp_id NUMBER, increment NUMBER) AS
BEGIN
UPDATE employees
SET salary = salary + increment
WHERE id = emp_id;
END;
To execute:
EXEC IncreaseSalary(101, 500);

Answer / hr@tgksolutions.com

A stored procedure is a precompiled block of PL/SQL code stored in the database, which can be executed to perform a specific task.
Syntax Example:
CREATE OR REPLACE PROCEDURE IncreaseSalary(emp_id NUMBER, increment NUMBER) AS
BEGIN
UPDATE employees
SET salary = salary + increment
WHERE id = emp_id;
END;
To execute:
EXEC IncreaseSalary(101, 500);

Answer / hr@tgksolutions.com

A stored procedure is a precompiled collection of SQL statements stored in the database. It improves performance and security by reducing query execution time.
Example:
CREATE PROCEDURE GetUsers()
AS
BEGIN
SELECT * FROM Users;
END;

What is the difference between nested table and varray?

0 Answers  

Is sqlite good enough for production?

0 Answers  

how to check server status with 'mysqladmin'? : Sql dba

0 Answers  

Can we use view in stored procedure?

0 Answers  

what are the different types of joins?

4 Answers   Choice Solutions,

Whate is use of MOD function in pl/sql.

3 Answers   Oracle,

what are the differences between binary and varbinary? : Sql dba

0 Answers  

How do I kill a query in postgresql?

0 Answers  

What are the types of queries in sql?

0 Answers  

What is implicit cursor in pl sql?

0 Answers  

How would you hide a table in sql. ie the table can be only visible to its maker?

3 Answers  

Can we debug stored procedure?

0 Answers