Oracle Database | The Codex Coding

Full guide coming soon. A complete spoonfed walkthrough of Oracle Database — what it is, when to use it, how to set it up, and how it connects to your code — is being written. For now, here is the short version.

What is Oracle Database?

The enterprise heavyweight. Powers banks and large corporations where reliability is non-negotiable.

Oracle Database Reference Topics 12 planned

These are the topics planned for this reference. They are not written yet — the list is published so you can see what is coming. Everything already complete on this site is linked from the Languages section.

What is Oracle Database Coming soon

Origin (1979, first commercial SQL RDBMS) and its enterprise dominance.

Guide in progress

Installing and Connecting Coming soon

Oracle Database editions, and the free Always Free tier on Oracle Cloud.

Guide in progress

PL/SQL Basics Coming soon

Oracle's procedural extension to SQL.

Guide in progress

Data Types in Oracle Coming soon

VARCHAR2, NUMBER, and Oracle-specific type conventions.

Guide in progress

Tables and Schemas Coming soon

Oracle's schema-per-user model.

Guide in progress

Querying with SQL Coming soon

Oracle's SQL dialect and its historic ROWNUM pagination.

Guide in progress

Joins and Relations Coming soon

Standard joins plus Oracle's legacy (+) outer join syntax.

Guide in progress

Transactions and ACID Coming soon

Oracle's multi-version read consistency model.

Guide in progress

Stored Procedures and Packages Coming soon

Bundling PL/SQL logic into reusable packages.

Guide in progress

Performance Tuning Coming soon

The cost-based optimizer and Oracle-specific tuning tools.

Guide in progress

Licensing and Editions Coming soon

Why Oracle licensing is famously complex — and costly.

Guide in progress

Connecting from Application Code Coming soon

Drivers like Oracle's own node-oracledb and JDBC.

Guide in progress

More in Databases

PostgreSQL MySQL SQLite MongoDB Redis