SQL vs PL/SQL vs SQL*Plus

SQL vs PL/SQL vs SQL*Plus

SQL (Structured Query Language)

Used to access, manipulate, and query data. It works with SELECT, INSERT, UPDATE, and DELETE statements.

SELECT * FROM employees WHERE department_id = 10;

PL/SQL (Procedural Language/SQL)

Oracle's extension to SQL that supports programming constructs like loops and conditions.

BEGIN
  FOR emp IN (SELECT * FROM employees) LOOP
    DBMS_OUTPUT.PUT_LINE(emp.last_name);
  END LOOP;
END;

SQL*Plus

A command-line interface for executing SQL and PL/SQL scripts, performing administration, and formatting reports.