Oracle PL/SQL Practice Scripts
This repository is a collection of Oracle PL/SQL scripts I created through self-practice and exploration of relational databases, SQL, and PL/SQL programming. It serves as a personal knowledge base and demonstrates my learning journey in building, managing, and interacting with databases using Oracle SQL Developer.
Key Areas Covered
Database Schema and Table Creation Scripts for designing and creating relational tables with constraints.
Stored Procedures and Functions Implementations for modular programming and reusable database logic.
Triggers Real-world simulations such as enforcing data integrity, formatting, and audit logging.
Exception Handling Examples of system-defined and user-defined exceptions for reliable error handling.
Transactions and Permissions Practical use of COMMIT, ROLLBACK, SAVEPOINT, and GRANT/REVOKE statements.
Control Structures and CASE Demonstrations of conditional logic and looping within PL/SQL blocks.
Analytical and Hierarchical Queries Advanced SQL features including hierarchical queries and analytical functions.
Practice Databases Sample datasets such as student records and book reviews for hands-on experiments.
Repository Contents
Create_Tables.sql → Schema and table creation scripts function.sql → Sample PL/SQL functions ProcedureCalling.sql → Examples of calling stored procedures Triggers.sql → Trigger implementations Transaction.sql → Transaction handling and rollback cases Case.sql → Usage of CASE expressions Exception.sql → Exception handling demonstrations Exercises.sql → General practice scripts Practice.sql → Extended practice examples with HR schema BookReviewsDB.sql → Sample book review database StudentTable.sql → Student dataset and queries Grant_Permissions.sql → Permissions and access management Week 12.sql → Hierarchical and analytical queries Plus other supporting files such as CodeTemplate.xml, etc.
Purpose
Strengthen my database development skills Practice real-world scenarios with PL/SQL Explore advanced Oracle SQL features Maintain a personal reference for future projects
Tools Used
Oracle SQL Developer Oracle Database (HR schema for practice)
Note
This repository is intended for personal study and exploration. Scripts may use sample datasets and are focused on learning PL/SQL concepts, not production deployment.