Connecting to Remote Databases Database links let you query tables and execute procedures on remote Oracle databases...
Cross-Cutting
Beyond LIKE and INSTR Most APEX applications implement search using WHERE column LIKE '%search_term%'. This works for...
Undo Your Mistakes Without a DBA Oracle’s Flashback Technology is a family of features that let developers...
JSON Is a First Class Citizen in Oracle Since Oracle 12c Release 1, JSON has been natively...
Why Developers Should Understand Partitioning Table partitioning is traditionally considered a DBA concern, but application developers benefit...
What Is Virtual Private Database Virtual Private Database (VPD) is an Oracle Database feature that transparently appends...
Automating Repetitive Tasks Many database applications need recurring tasks: nightly data purges, hourly report generation, periodic email...
Reaching Out From the Database Modern applications rarely live in isolation. Your Oracle database may need to...
Dashboards Need Precomputed Data APEX dashboards that aggregate millions of rows for charts and summary cards can...
A New Kind of Reuse in SQL SQL macros, introduced in Oracle 21c, let you write PL/SQL...