Roby

• May 23rd, 2005

 

Stored Procedure is a stored program in the datbase

SaiSrinivas

• May 30th, 2005

 

Stored Procedure is a stored program in database, PL/SQL program is a Stored Procedure. Stored Procedures can be called from java by CallableStatement

moshe dayan

• Jun 2nd, 2005

 

A stored procedure is a group of SQL statements that form a logical unit and perform a particular task. Stored procedures are used to encapsulate a set of operations or queries to execute on a database server. For example, operations on an employee database (hire, fire, promote, lookup) could be coded as stored procedures executed by application code. Stored procedures can be compiled and executed with different parameters and results, and they may have any combination of input, output, and input/output parameters.

Arundathi

• Jun 30th, 2005

 

A precompiled collection of SQL statements stored under a name and processed as a unit.  
Stored procedures can:  
1.Accept input parameters and return multiple values in the form of output parameters to the calling procedure or batch. 
2.Contain programming statements that perform operations in the database, including calling other procedures.  
3.Return a status value to a calling procedure or batch to indicate success or failure (and the reason for failure).  

Subramanyam

• Aug 1st, 2005

 

A stored procedure is a set of procedural sql querry which when executed under sql environment will perform those operations which are specified in those sql querry form

v.vamshi krishna

• Aug 24th, 2005

 

send the code for a sample jdbc program

tulasi

• Sep 7th, 2005

 

stored procedure is nothing but a colletion of sql statements with conditional structures to perform one or more tasks combinedly.which is compiled and can call other stored procedures..

guptach

 Profile Answers by guptach 

• Sep 22nd, 2005

 

A stored procedure or function is an object stored in the database, and run as a unit to solve a specific problem or perform a set of related tasks. Procedures and functions permit the caller to provide parameters that can be input only, output only, or input and output values. A procedure is explicitly run by a user, application, or trigger.

Procedures and functions are identical except that functions always return a single value to the caller, while procedures do not.

Hameed

• Oct 12th, 2005

 

Stored Procedure is an object design with business logic and stored in the database .Since it stays in the database ,the execution of the business logic is more faster...

pradeepkmr18

 Profile Answers by pradeepkmr18 

• Jul 3rd, 2008

 

Stored procedure contains set of sQL Statements thar are executed in the database by the sql stament processor.

code:

DECLARE
 NUM1 NUMBER:=10;
 NUM2 NUMBER:=20;
BEGIN
    DBMS_OUTPUT.PUT_LINE('sum:'||To_Char(NUM1+NUM2,'999.99'));
END;