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

Popular posts from this blog

SPSS keyboard combination alters encoding -

Socket.connect doesn't throw exception in Android -

iphone - How do I keep MDScrollView from truncating my row headers and making my cells look bad? -