Explain Triggers and Stored Procedures?

devquora
devquora

Posted On: Feb 22, 2018

 

A trigger can be defined as that stored procedure that executes when some particular event happens in SQL such as update, insert, delete, etc. On the other hand, a stored procedure is a piece of code purely defined by the user and is written in several local versions of PL or SQL. A stored procedure may return a value if it is made a function and can be invoked by calling it explicitly.

    Related Questions

    Please Login or Register to leave a response.

    Related Questions

    Appinventiv Php Developer Interview Questions

    How to find datatype of variable in PHP?

    You can find the datatype of a variable in PHP by using the Var_dump() and gettype() functions....

    Appinventiv Php Developer Interview Questions

    What is Interface? Why it is used?

    An interface can be defined as a platform that permits users to develop programs that mention all public methods that need to be implemented by various classes. It does not involve any complexity or d...