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 |