DATABASE & SQL/PLSQL

How To Create Stored Procedure
Previous Home Next

Guideline

  1. Identify the database in which the stored procedure has to be created
  2. Determine the type of stored procedure
  3. Determine the name for the stored procedure
  4. Write the batch statement
Syntax
CREATE PROCEDURE  proc_name
AS
BEGIN
           sql-statement 1
           sql-statement 1
END

where, proc_name specifies the name of the stored procedure.

 

Example


CREATE PROCEDURE  empNameList
AS
BEGIN
           SELECT  'Employee'=emp_name, 'Salary'=emp_sal
           FROM  employee
END

Stored Procedure Created.

Check the existence of the procedure in the database

Syntax

sp_helptext  proc_name

sp_helptext  empNameList

output

Execute the procedure

Syntax
EXECUTE  proc_name

EXECUTE  empNameList

output

Previous Home Next

Tolal:0 Click:

Show All Comments

Did not find what you were looking for leave your name and message. We will revert within 24 hours
Name:
eMail:
Comment / Feedback: