PL/SQL

PL/SQL extends SQL with procedural logic (variables, loops, conditions, functions) inside the Oracle database. It lets you create stored procedures and triggers, and is fundamental in large enterprise systems on Oracle.

• Creado por Oracle
• Año 1992
• Paradigma: Procedural · interpreted
• Extensiones: .pls, .plsql, .sql

Para qué se usa

• Stored procedures
• Logic in the database
• Oracle systems

A favor

• Powerful on Oracle
• Logic next to the data
• Very mature

En contra

• Tied to Oracle
• Verbose
• Only in its environment

Ecosistema

• Oracle Database
• SQL Developer
• Oracle APEX
• TOAD

Ejemplo

BEGIN
  DBMS_OUTPUT.PUT_LINE('¡Hola, mundo!');
END;