PL/SQL 🚀

Entrenamiento completo de PL/SQL de Principiante a Avanzado

EJEMPLO - BLOQUE ANONIMO 📄

DECLARE
    --Se declaran variables;
BEGIN
    [LOGICA]
END;

Temas Aprendidos 📋

• PL/SQL Terminologies
• PL/SQL Architecture
• PL/SQL Variables
• PL/SQL Control Structures
  • If-Then-Else Structure
  • Case Expressions
  • Loops
    • While Loop
    • For Loop
    • Nested Loop
    • Loop Labeling
    • Continue Statement
    • GOTO Statement
• Using SQL inside PL/SQL
• PL/SQL Cursors
• Using PL/SQL Program Units (Functions & Procedures)
• PL/SQL Packages
• PL/SQL Exceptions & Exception Handling
• PL/SQL Debugging
• Dynamic SQL & PL/SQL
• PL/SQL Composite Data Types (Collections)
  • Associative Arrays
  • Nested Tables
  • Varrays
  • Records
• PL/SQL Triggers
• Oracle-Supplied Packages
• Using Large Objects in PL/SQL (LOBs)
• Using PL/SQL Object Oriented
• Using PL/SQL Compiler
• PL/SQL Performance &Tuning
• PL/SQL Caching
• PL/SQL Security
• PL/SQL Fine-Grained Access Control (VPD)
• PL/SQL Hints
• PL/SQL Object Dependencies
• Designing Better PL/SQL
• Using Java in PL/SQL
• Managing Dependencies