SQL Differences between stored procedure and triggers -


i'm having trouble understanding difference between stored procedure , trigger in sql. if kind enough explain me great.

thanks in advance

a stored procedure user defined piece of code written in local version of pl/sql, may return value (making function) invoked calling explicitly.

a trigger stored procedure runs automatically when various events happen (eg update, insert, delete).

imho stored procedures to avoided unless absolutely required.


Comments