DBMS Lab Solutions

Academic DBMS lab solutions aligned with the 4th-semester syllabus (BPPIMT), written specifically for Oracle Database Express Edition (Oracle XE).

---

📂 Navigation

🎓 Lab Notebook Preparation

• BCA 4th Sem Lab Notebook Solutions (1-5)

📝 Semester Assignments

• Assignment 1-2: Employee Queries
• Assignment 3: EMP & DEPT
• Assignment 4: Joins & Subqueries
• Assignment 5: SQL Functions
• Assignment 6: Exception Handling
• Assignment 7: Cursors
• Assignment 8: Procedures & Functions
• Assignment 9: Database Triggers
• Assignment 10: PL/SQL Packages
• Assignment 11: Package Overloading
• Assignment 12: Advanced Triggers
• Assignment 13: Interactive PL/SQL

---

⚡ Quick Start

Database Reset

To drop all existing tables and start with a clean environment in your Oracle APEX or SQL workspace, run this block:

BEGIN
  FOR r IN (SELECT table_name FROM user_tables) LOOP
    EXECUTE IMMEDIATE 'DROP TABLE "' || r.table_name || '" CASCADE CONSTRAINTS PURGE';
  END LOOP;
END;
/

---

📦 Installer Bundle

The Debian-compatible installation bundle Linux-DBMS.zip (Oracle XE 10g) is hosted on GitHub Releases.