Oracle · Software · YoctoIT tech page

APEX

Low-code on the database: enterprise applications in days, right on the data — included in every Oracle Database.

FOCUS · LOW-CODE, SERIOUSLYDepartmental apps in days, secure and already connected to the data
YoctoIT material for clients and partners · Oracle, Exadata, GoldenGate and the other products mentioned are trademarks of Oracle Corporation and/or its affiliates.
01 · What it is

Oracle APEX, made clear.

APEX is the low-code platform included in the Oracle database: forms, reports, dashboards and flows built visually right on the tables, with security and sessions managed by the engine. The right place for the dozens of departmental apps that today live in Excel and Access.

Included
no extra licenses: it's already in your database
Days
the time-to-app for departmental needs
On the data
apps are born where the data lives: no sync, no copies
Oracle APEX
OFFICIAL ORACLE BRANDING · APEX
INTERFACCIA REALE · APEX APP BUILDER · FONTE: ORACLE BLOG
REAL INTERFACE · APEX APP BUILDER · SOURCE: ORACLE BLOG
02 · How to use it well

The things that make the difference.

Where it lives

Users (web, mobile-ready)modern, responsive interfaces
Forms & reports
Workflow
REST & integration
the low-code bricks
APEX engine (in the database)security and sessions from the engine
Oracle DB · on-prem or Autonomousthe platform you already have
The app one SELECT away

From Excels to apps

The shared spreadsheets with 14 versions become an app with permissions, history and audit.

Low-code governance

Environments, versioning and standards: citizen development without the wild west.

REST integration

APEX calls and exposes APIs: the low-code that talks to the rest of the system.

Inherited security

Corporate authentication and the database's VPD: the app is born compliant.

03 · In depth

Enterprise low-code, seriously

APEX generates complete web applications right on Oracle data: declarative pages (interactive reports, faceted search, cards), integrated security (authentication schemes, role-based authorization, protected session state), REST sources for external data, native workflows and approvals. It runs wherever there's an Oracle database — Autonomous included, where it's free — and is versioned and exported as code.

  • Declarative — interactive reports and forms generated on the data model: days, not months
  • Integrated security — authentication, authorization and session protection already in the framework
  • REST sources — external data as if it were tables: declarative integration
  • Workflow — native approvals and human tasks: processes truly digitized
  • Included on Autonomous — zero additional licenses: low-code without a price list
  • Export come codice — versionable in Git: a real software lifecycle
04 · Numbers and lifecycle

The numbers that matter.

10x
the typical speed vs traditional development for data-centric apps
0
license cost on Autonomous and on existing databases
2/anno
the APEX releases: a living platform
1
skill required: SQL — the framework does the rest
Low-code pays off with governance: standards, security and deployment set up by us — departmental apps without shadow IT.
05 · Use cases

Where it really pays off.

Departmental apps

Requests, censuses, approvals: IT's long tail.

Forms modernization

The natural way out of Oracle Forms.

Prototypes that stay

The mock that becomes production without a rewrite.

Serious low-code stays close to the data: APEX is free, we bring the method.