what are the differences between stored procedure and triggers in SQL?

Question

Accepted Answer

Stored procedures are precompiled SQL statements that can be executed on demand, while triggers are automatically executed in response to specific events.

Stored procedures are explicitly called by the user, while triggers are automatically invoked by the database system.
Stored procedures can accept parameters and return values, while triggers cannot.
Stored procedures can be executed independently, while triggers are always associated with a specific table or view.
Stored procedures can perform complex business logic and multiple SQL statements, while triggers are typically used for data validation or auditing purposes.
Examples: A stored procedure can be used to update multiple tables when a user makes a purchase, while a trigger can be used to automatically update a 'last modified' timestamp when a row is updated.

Accepted Answer

A sttore procedure is a user defind piece of code written in the local verion of PL/SQL, which may return a value (making it a function ) that is invoked by calling it explicity. A trigger is a stored procedure that runs automatically when various event happen

Accepted Answer

A sttore procedure is a user defind piece of code written in the local verion of PL/SQL, which may return a value (making it a function ) that is invoked by calling it explicity. A trigger is a stored procedure that runs automatically when various event happen

Accepted Answer

triggers means executes automatically in response to certain events(such as updates,inserts ,and deletions)
it has the ability  to run automatically in response to events.
stored procedure are sections of pl/sql code that perform a specified operation
it can be called by the user explicitly
it has the ability to accept input as a parameter

what are the differences between stored procedure and triggers in SQL?

Top Deloitte Software Engineer interview questions & answers

Popular interview questions of Software Engineer

Top HR questions asked in Deloitte Software Engineer