What are triggers and stored Procedures?
A procedure is a group of PL/SQL statement that you call by a name. Compiled version of procedure that is stored in a database are known as Stored Procedures. A database trigger is a stored procedure that is associated with a table. Oracle automatically fires or executes when a triggering statement is issued.