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

.htaccess - First slash is removed after domain when entering a webpage in the browser -

Socket.connect doesn't throw exception in Android -

SPSS keyboard combination alters encoding -