Oracle has officially released Oracle APEX 26.1, introducing powerful AI capabilities, improved developer productivity, enhanced security, and a more modern user experience. This release represents one of the most significant updates in recent years, bringing over 90 community-requested improvements alongside groundbreaking AI features.
What is Oracle APEX 26.1?
Oracle APEX 26.1 is the latest version of Oracle’s low-code development platform that enables developers to build secure, scalable, and enterprise-grade applications faster. The new release focuses heavily on AI-assisted development, collaboration, and modern application architecture.
Major Features in Oracle APEX 26.1
1. APEXlang โ Open Application Specification Language
One of the biggest innovations in APEX 26.1 is APEXlang, a new human-readable application specification format.
Key Benefits
- Easy to read and maintain.
- Better integration with Git and version control systems.
- AI-friendly application development.
- Simplified code reviews and collaboration.
- .apx files can serve as the application’s source of truth.
This feature makes Oracle APEX applications easier to manage and opens the door for AI-assisted development.
2. AI Agents
Oracle APEX 26.1 introduces built-in AI Agents capable of:
- Understanding user requests.
- Retrieving database information.
- Executing PL/SQL code.
- Performing approved actions through AI tools.
- Maintaining developer-controlled security boundaries.
AI Agents bring conversational and autonomous capabilities directly into APEX applications.
3. AI Interactive Reports
Interactive Reports now support natural language queries.
Users can simply ask:
“Show sales data for 2025 sorted by revenue.”
APEX automatically generates:
- Filters
- Sorts
- Aggregations
- Charts
- Highlights
- Breaks
without generating AI-written SQL, making reporting both powerful and secure.
4. Create Pages Using Natural Language
Developers can now create pages by simply describing what they want.
Example:
Create a report on EMPLOYEES table.
APEX can automatically suggest:
- Page type
- Page name
- Data source
- Layout
This significantly speeds up application development.
5. Data Reporter
Data Reporter is a new self-service reporting solution.
Business users can:
- Create reports without development knowledge.
- Publish reports.
- Share reports via URL.
- Work with trusted datasets managed by administrators.
This empowers end users while maintaining governance and security.
6. Universal Theme 26.1
Oracle introduces a fresh new look with the Iris Theme Style.
Enhancements include:
- New Metric Card component.
- Blank Page template.
- Grouped Avatars and Timelines.
- Expanded Font APEX 2.5 icons.
- Badge support on buttons.
- Improved drawers and dialogs.
- Additional utility CSS classes.
These improvements help developers create more modern and responsive applications.
7. Dynamic Action Enhancements
New declarative actions eliminate the need for custom JavaScript.
New actions include:
- Show Success Message
- Show Error Message
- Clear Errors
- Wait Popup
This simplifies development and improves maintainability.
8. Interactive Report Enhancements
Interactive Reports now support:
- Row selection.
- Improved filtering.
- Better template component integration.
These enhancements provide greater flexibility and usability.
9. Clipboard Support
Users can now paste files directly into:
- File Upload items.
- Image Upload items.
Simply use:
- Ctrl + V (Windows)
- Cmd + V (Mac)
This creates a smoother user experience.
10. Describe Tables Utility
A new utility under SQL Workshop provides AI-friendly table descriptions.
It can generate:
- Markdown output.
- Plain text documentation.
Including:
- Columns
- Data types
- Comments
- Constraints
- Indexes
This feature is especially useful for documentation and AI integration.
11. Enhanced Security and CSP Compliance
Oracle APEX 26.1 significantly improves Content Security Policy (CSP) support.
Benefits include:
- Reduced reliance on unsafe-inline scripts.
- Elimination of unsafe-hashes.
- Improved browser security.
- Stronger enterprise compliance.
These enhancements make applications more secure and easier to certify.
12. Developer Experience Improvements
Developers benefit from:
- Refined App Builder interface.
- Workspace search.
- Context-rich diff views.
- Improved workflow APIs.
- Better multi-tenancy support.
These features increase productivity throughout the development lifecycle.
Why Upgrade to Oracle APEX 26.1?
Oracle APEX 26.1 provides:
โ AI-powered application development
โ Human-readable APEXlang files
โ Natural language reporting
โ Enhanced security
โ Modern UI components
โ Better developer productivity
โ Improved workflows
โ More than 90 community-driven enhancements
Final Thoughts
Oracle APEX 26.1 marks a major evolution of the platform. With the introduction of APEXlang, AI Agents, AI Interactive Reports, and numerous usability improvements, developers can build smarter, more secure, and more maintainable applications than ever before.
Whether you are an Oracle DBA, APEX developer, or enterprise architect, upgrading to Oracle APEX 26.1 offers substantial benefits for both development teams and end users.
