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;

hi..........i m Accenture employee...Accenture is an IT company having itz branches in India at Mumbai, Pune,Delhi, Hyderabad, Chennai and Bangalore....Presently there are openings here for SAP, Testing, Oracle,Java,.NET,MAinframe and Peoplesoft...... I am a software engineer working with Accenture,Mumbai....u can mail me in your resume..i`ll forward it to our HR team...my mail id: pankit.lodaya@accenture.com

8 Answers   Wipro,

List the differences between plsql - function & procedures

2 Answers   TCS, Verizon,

What is the example of procedure?

1 Answers  

what is difference between "Primary key" and "Unique key"?

4 Answers   PreVator,

What is an implicit commit?

1 Answers  

i have table T!. A B C D NULL 1 2 3 4 NULL 5 6 7 8 NULL 9 10 11 12 NULL. I WANT COUNT OF NULL VALUES IN TABLE. WRITE A QUERY.

14 Answers   iGate, Wipro,

ename empno deptno amar 1 10 akbar 2 20 anthonny 3 30 jonathan 4 40 write a procedure to dispaly the column values ina row separated by a deleimiter eg - input - select ename from emp '|' output - amar|akbar|anthony|jonathan input - select empno from emp '@' o/p - 1@2@3@4 input - select deptno from emp '/' o/p - 10/20/30/40 Pls answer this questn.

2 Answers  

Can we use rowid as primary key?

1 Answers  

What is a call statement? Explain with an example.

1 Answers  

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

1 Answers  

how to see the create table statement of an existing table? : Sql dba

1 Answers  

What is a sql instance vs database?

1 Answers