Triggers Vs Cursors

 

Triggers are named PL/SQL blocks

Cursors are temporary work areas

Triggers are stored in databases

Cursors are not stored independently in the database

Triggers can be invoked automatically

User can create cursor both implicitly and explicitly

Triggers cannot take parameters

Cursors can take parameters

Triggers are used to enforce data in dignity rules

Cursors are used to process the result of query