Description
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.
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.
Brewbeans wants to allow customers to do product search by selecting a product name or description, and then typing a search term. Using native dynamic SQL, create a procedure named SEARCH_SP that returns the product name, description, and price based on users’ search criteria. This procedure needs to handle multiple rows being returned.
