This repository showcases an Oracle PL/SQL project designed to manage client contracts and generate installments dynamically. This project was developed as part of the Oracle course in the Data Visualization track at the Information Technology Institute (ITI). The system automates the calculation and scheduling of installments based on contract terms.
- Create and manage clients, contracts, and installment schedules.
- Dynamic calculation of installment amounts.
- Automates insertions using sequences for unique IDs.
- Handles different payment types (annual, quarterly, monthly).
scripts/: Contains SQL scripts for schema creation, data insertion, and dynamic installment generation.ReadMe.md: Documentation for project overview and usage instructions.examples/: Test cases and sample outputs.
- Oracle Database: Version 11g or later.
- SQL*Plus or PL/SQL Developer: For executing scripts.
- Clone the repository:
git clone https://github.com/walid798/ORACLE_PROJECT.git cd ORACLE_PROJECT