Oracle SQL and PL/SQL Practice

This repository contains practice exercises and solutions for Oracle SQL and PL/SQL programming, covering fundamental to advanced database concepts.

🎯 Topics Covered

Oracle SQL

• DDL (Data Definition Language) - CREATE, ALTER, DROP, TRUNCATE
• DML (Data Manipulation Language) - INSERT, UPDATE, DELETE, MERGE
• DQL (Data Query Language) - SELECT statements, JOINs, subqueries
• DCL (Data Control Language) - GRANT, REVOKE

PL/SQL

• Basics - Variables, data types, control structures
• Functions - User-defined functions, built-in functions
• Procedures - Stored procedures, parameter handling
• Exceptions - Error handling, custom exceptions
• Triggers - DML triggers, DDL triggers, system triggers
• Packages - Package specification and body, encapsulation

📁 Project Structure

oracle-PLSQL/
├── solutions/          # Exercise solutions organized by series
│   ├── serie1/        # Series 1 exercises
│   │   ├── EX1.sql
│   │   └── EX2.sql
│   ├── serie2/        # Series 2 exercises
│   │   ├── EX1.sql
│   │   ├── EX2.sql
│   │   ├── EX3.sql
│   │   └── EX4.sql
│   ├── serie3/        # Series 3 practical work (TP)
│   │   ├── TP1.sql
│   │   └── TP2.sql
│   └── serie4/        # Series 4 exercises
│       └── EX.sql
├── src/setup/         # Database setup scripts
│   ├── serie1/
│   │   ├── setup_ex1.sql
│   │   └── setup_ex2.sql
│   ├── serie2/
│   │   └── setup_ex1.sql
│   ├── serie3/
│   │   └── setup_TP2.sql
│   └── serie4/
│       └── setup_S4.sql
└── series/            # Exercise descriptions (if applicable)

🚀 Getting Started

Prerequisites

• Oracle Database (11g or higher recommended)
• SQL*Plus, SQLcl, or Oracle SQL Developer
• Basic understanding of SQL and PL/SQL