Welcome to the PL/SQL Course! This repository is designed to help you learn Oracle PL/SQL from the basics to advanced concepts. PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural extension for SQL and the Oracle relational database. It combines the data manipulation power of SQL with the processing power of procedural languages.
This course is structured in a logical sequence, starting from the fundamentals and progressing to advanced topics. Each topic is covered in a dedicated markdown file for easy navigation and focused learning.
# | Topic | Link |
---|---|---|
1 | Introduction to PL/SQL | 01-introduction.md |
2 | PL/SQL Block Structure | 02-block-structure.md |
3 | Variables and Data Types | 03-variables.md |
4 | Control Structures (IF, CASE, LOOP) | 04-control-structures.md |
5 | Cursors | 05-cursors.md |
6 | Exception Handling | 06-exception-handling.md |
7 | Procedures and Functions | 07-procedures-functions.md |
8 | Packages | 08-packages.md |
9 | Triggers | 09-triggers.md |
10 | Records and Collections | 10-records-collections.md |
11 | Bulk Processing (FORALL, BULK COLLECT) | 11-bulk-processing.md |
12 | Dynamic SQL | 12-dynamic-sql.md |
13 | Advanced Topics | 13-advanced-topics.md |
Feel free to navigate through the topics above. Each link will take you to a detailed explanation and examples for that topic. Happy learning!
Introduction to PL/SQL Declaring PL/SQL Variables Writing Executable Statements Using SQL Statements Within a PL/SQL Block Writing Control Structures Working with Composite Data Types Using Explicit Cursors Handling Exceptions Introducing Stored Procedures and Functions Creating Procedures Creating Functions Debugging Subprograms Creating Packages Working with Packages Creating Triggers Creating Compound, DDL, and Event Database Triggers Design Considerations for the PL/SQL Code Managing Dependencies Using SQL Developer Using SQL*Plus Commonly Used SQL Commands REF Cursors Managing PL/SQL Code Implementing Triggers JSON and XML Processing SQL And PLSQL Certification Guide