storedprocedure: is set of sql statements which is compiled in sql database table.
syntax: create or replace prcedure procedure_name (argument_list<in,out>);
Example of stored procedure: create or replace procedure sp_interest (id in integer,bal out float)as begin select balance into bal from accounts where acc_id=id; bal:=bal+bal*0.03; update accounts set balance=bal where acc_id=id; end; Source: CoolInterview.com