The assignment is a series of PL/SQL procedures that perform various tasks, including creating a new customer account, updating a customer's address, and displaying the sum of balances by state. The procedures use SQL commands to interact with tables in an Oracle database.

Oracle PL/SQL procedures for managing customer accounts, transactions, and addresses.

Exploring PL/SQL: Procedures and Triggers

The assignment content includes four procedures in Oracle PL/SQL. The first procedure, `add_new_account`, adds a new account to the database if the input is valid. If not, it raises an exception and displays an error message. The second procedure, `state_balance`, displays the sum of balances for a given state. The third procedure, `address_update`, updates a customer's address if the customer ID exists in the database. If the customer ID does not exist, it raises an exception and displays an error message. The fourth procedure, `transac_history`, displays all transactions with amounts greater than or equal to a specified amount. Finally, the extra credit task involves creating a trigger that logs changes to a customer's address.

Enter the customer id:

Report

The assignment provides a set of procedures in Oracle PL/SQL that perform various database operations. The procedures include: (1) Adding a new account for an existing customer, which verifies the customer ID and account type before creating the new account; (2) Displaying the sum of balances by state; (3) Updating a customer's address; and (4) Displaying transaction history with amounts greater than a specified amount. The procedures also include error handling to return messages in case of failure or invalid input.

System Procedures

This assignment is a series of PL/SQL procedures and triggers designed to handle transactions on valid accounts for valid customers while maintaining the integrity of account balances. The system should allow deposits, withdrawals, transfers between accounts, and address updates. The system should also provide messages with the success or failure of each action. Additionally, there are procedures to display the sum of balances by state, update customer addresses, and display account numbers, last names, and amounts for transactions greater than a specified amount.

Exploring PL/SQL: Procedures and Triggers

End of preview

Enter the customer id:

System Procedures

Transaction and Customer Management System

Exploring PL/SQL: Procedures and Triggers

End of preview

Enter the customer id:lg...

System Procedureslg...

Transaction and Customer Management Systemlg...

Enter the customer id:

System Procedures

Transaction and Customer Management System