| name | oracle |
| description | Oracle Database with PL/SQL, RAC, and enterprise features. Use for enterprise systems. |
Oracle Database
Oracle Database is a multi-model database management system. It is the de-facto standard for Fortune 500 mission-critical systems due to its reliability, scalability (RAC), and PL/SQL power.
When to Use
- Mission Critical: Banking, Airlines, Telecoms where 99.999% uptime is required.
- PL/SQL: When you have massive business logic that needs to run close to the data.
- Complex Workloads: OLTP and OLAP in the same DB.
Quick Start
BEGIN
FOR r IN (SELECT first_name, last_name FROM employees WHERE department_id = 10)
LOOP
DBMS_OUTPUT.PUT_LINE(r.first_name || ' ' || r.last_name);
END LOOP;
END;
/
Core Concepts
PL/SQL
Procedural Language/SQL. Extremely mature and powerful language stored within the DB.
RAC (Real Application Clusters)
Allows multiple servers to access the same database storage simultaneously. If one server fails, the others keep running (High Availability).
Multi-Tenant (CDB/PDB)
One Container Database (CDB) hosts multiple Pluggable Databases (PDBs). Efficient resource sharing.
