🟣Oracle SQL Database – Exercises & Solutions A comprehensive collection of solved exercises to help you master Oracle SQL — from beginner-friendly SELECT statements to advanced topics like subqueries, triggers, and set operators.

📚Topics Covered ✅ Basic Queries (SELECT, WHERE, ORDER BY)

✅ Joins (INNER, LEFT, RIGHT, FULL OUTER)

✅ Aggregate Functions (SUM, AVG, COUNT, etc.)

✅ GROUP BY and HAVING Clauses

✅ Subqueries & Nested Queries

✅ Set Operators (UNION, INTERSECT, MINUS)

✅ Views, Indexes, and Sequences

✅ DDL: CREATE, ALTER, DROP

✅ DML: INSERT, UPDATE, DELETE

✅ PL/SQL Basics – Procedures, Functions, Triggers

🚀How to Use Set up the schema using the SQL scripts in the /setup/ directory (based on Oracle's HR-style structure).

Explore the problems under /exercises/ — these are designed for practice and revision.

Check your answers or learn from the /solutions/ folder.

Customize or expand the queries to deepen your understanding.

🎯 Repository Goals Strengthen real-world Oracle SQL problem-solving.

Prepare for technical interviews and academic exams.

Provide a structured and practical reference for Oracle database learners.

💡Requirements Oracle Database (11g or above recommended)

SQL Developer or any Oracle-compatible client

🤝 Contributions Welcome! Have new exercises? Found a better approach? Feel free to:

Fork this repo 🔀

Add exercises or solutions 📥

Submit a Pull Request 💡

Let’s make this a go-to resource for all SQL learners!

📜 License This repository is open for educational use. Attribution is appreciated. No commercial use without permission.