What is stored procedure? explain the syntax

Hi friend,

A stored procedure is a group of SQL statements that form a logical unit and perform a particular task, and they are used to encapsulate a set of operations or queries to execute on a database server.

Eg:

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.

Syntax:

create procedure SHOW_SUPPLIERS
as
select SUPPLIERS.SUP_NAME, COFFEES.COF_NAME
from SUPPLIERS, COFFEES
where SUPPLIERS.SUP_ID = COFFEES.SUP_ID
order by SUP_NAME

Thanks,
Riju.

May i know your syntax belongs to which RDBMS ?

Hi i want to clear my concepts on Joins and on Normalization topics.

Could you please refer me the site please so that i can start directly reading from the site!