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;

When do we create bitmap indexes

2 Answers   CTS,

What is a stored procedure in sql with example?

0 Answers  

What is a primary key called that is made up of more than one field?

0 Answers  

What is pl/sql and what is it used for?

4 Answers  

What are sql triggers used for?

0 Answers  

how view used for security purposes?

3 Answers   Glam India,

What is normalization in sql?

0 Answers  

How do you write a subquery?

0 Answers  

How to come back in normal stage in Mutating Table if mutating table is locked or update data?

2 Answers  

I have a small PL/SQL Block assume in this way begin select * from emp where empno=100; exception when others then <Some Messages> when no_data_found then <Some Messages> when too_many_rows then <Some Messages> end; The question which he asked was whether this block will get executed normally or it will throw error ? If errored out then what is the reason for the error ? Could anybody please help me ? Regards Nakul Venkataraman

3 Answers   Satyam,

What is coalesce in sql?

0 Answers  

Why is pl sql used?

0 Answers