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...

    Error
    Whoops, looks like something went wrong.