DATABASE & SQL/PLSQL

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

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