Oracle Finance Interview Question

Explain and write code for trigger. How is trigger and procedure different?

Interview Answer

Anonymous

Oct 2, 2024

A procedure is a combination of SQL statements written to perform specified tasks. It helps in code re-usability and saves time and lines of code. A trigger is a special kind of procedure that executes only when some triggering event such as INSERT, UPDATE, or DELETE operations occur in a table.