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;

discuss about myisam key cache. : Sql dba

0 Answers  

What is the difference between between and in condition operators?

0 Answers  

can sql servers linked to other servers like oracle? : Sql dba

0 Answers  

Name the operator which is used in the query for pattern matching?

0 Answers  

Can you load data into multiple tables at once? : aql loader

0 Answers  

What is clause in sql?

0 Answers  

Why truncate is used in sql?

0 Answers  

Write a simple program on cursors

2 Answers   BirlaSoft,

tell me about various levels of constraint. : Sql dba

0 Answers  

What is the difference between inner join and left join?

0 Answers  

What is the default value of CHAR type?

3 Answers   Bosch,

what are the methods using performance tunning in sql and pl/sql

2 Answers