Oracle PL/SQL Assignment 9-9: Tracking Pledge Payment Activity

The DoGood Donor organization wants to track all pledge payment activity. Each time a pledge payment is added, changed, or removed, the following information should be captured in a separate table: username (logon), current date, action taken (INSERT, UPDATE, or DELETE), and the idpay value for the payment record. Create a table named DD_PAYTRACK to hold this information. Include a primary key column to be populated by a sequence, and create a new sequence named DD_PTRACK_SEQ for the primary key column. Create a single trigger for recording the requested information to track pledge payment activity, and test the trigger.