Oracle APEX offers all the tools you need to be productive, deliver on time, and produce stunning results for your business.
Oracle APEX minimizes the complexity involved with multi-faceted applications and provides developers with the features they need to solve business problems without needing to become experts in vast web technologies. Explore how Oracle APEX helps you build better apps by taking care of these six facets of application development:
Oracle APEX strives to make it as easy as possible for you to display, manipulate, chart, and process data as easily and efficiently as possible. No matter where your data comes from, whether it is from a local database, remote database, or a web service, Oracle APEX features state-of-the-art functionality to help you turn data into information.
Turn Data into Information
Everybody sees data differently. With the Interactive Report component, you can empower your users to easily customize the data they see in a way that uniquely satisfies their needs. From simple changes like determining which columns to show, to more sophisticated customizations such as pivoting data, it is all within reach.
Search. Filter. Find.
Fast search and sophisticated filtering enable users to quickly and easily find what they are looking for. This can be achieved through full row searches, column-specific filtering, or even more complex filtering expressions such as filtering based on multiple column's values.
Tailored. Just for you.
Fully customize the report by applying simple formatting such as sorting and grouping the data with control breaks, enriching the data with custom highlights, computations or aggregates, or view the data in an entirely new way using charts, group by and pivot views.
Your Report. Remembered.
You don't need to apply these customizations and filters every time – simply save the report and all of your customizations will be remembered for your next visit. You can choose to save a report privately, just for yourself, or publicly, so it can be viewed by others.
Edit Data. Effortlessly.
Editing data should be effortless. With the Interactive Grid component, it's easy to rapidly edit multiple rows of data — as simple as clicking on a cell and editing its value. If your users are familiar with spreadsheets, they'll feel right at home, with features like row and column selection, copy down, fill, and much more. Unlock the full potential of your data in an easy to use and highly customizable way with Interactive Grids.
Full Featured Grid
Interactive Grid includes all the features you expect for powerful reporting, including fixed headers, frozen columns, scroll pagination, multiple filters, sorting, aggregates, and more.
You can easily edit your data using text, numerical columns, date pickers, list of values, and much more. Interactive Grid is designed to support all item types and item type plug-ins.
Master Detail. And Detail. And Detail.
With Interactive Grids, you can now easily render master-detail-detail relationships that can be n-levels deep or across. You can create all types of master-detail-detail screens with ease.
Enjoy powerful chart and visualization capabilities in Application Express with, powered by Oracle JET. You can easily add beautiful, fast, highly customizable, accessible, and extremely versatile charts to your applications with ease.
These charts are fully HTML5 capable and work on any modern browser, regardless of platform, screen size, or features.
Through the use of a large range of declarative chart attributes, you have the flexibility to customize your charts, and make your applications soar with great visualizations, transforming operational data into actionable information.
The charts provide dozens of different ways to visualize a data set, including bar, line, area, range, combination, scatter, bubble, polar, pyramid, radar, pie, donut, funnel, dial gauge, stock and Gantt charts.
Local. Remote. REST. Access.
It is now easier than ever to integrate data from a variety sources, whether it is from your local database, a remote Oracle database, or from any web service. You can even use Oracle APEX to publish web services using the built-in REST Workshop!
Consume Web Services
Easily access data from web services from a variety of REST endpoints, including ordinary REST data feeds, REST Services from Oracle REST Data Services, and Oracle Cloud Applications REST Services. In addition to supporting smart caching rules for remote REST data, APEX also offers the unique ability to directly manipulate the results of REST data sources using industry standard SQL.
SQL on Remote Databases
Say good bye to database links. With REST-Enabled SQL Services from Oracle REST Data Services, you can now access data and execute SQL on remote Oracle databases over HTTP and REST. Now you can easily build apps that integrate data from remote Oracle databases and allow Oracle APEX to become an application server.
Build REST APIs
With the completely rearchitected REST Workshop, you can easily build web services against your Oracle database objects. These service definitions are managed in a single repository and can be edited from Oracle APEX, SQL Developer, or via PL/SQL APIs. You can even generate Swagger documentation with a single click!
Forms and Automatic Data Model Processing
Form pages allow end users to view and edit a single row of data in a database table or view. Choosing from a large variety of form item types, developers can create responsive and easy to use forms that interface with the database through automatic DML processing as well as through Dynamic Actions and AJAX.
Forms provide automatic row fetch and automatic row processing, which loads the requested row automatically from the underlying database table, maps table columns to form items and populates the form items with data. When submitting a page, all form data is written back to the database table while ensuring data integrity.
To ensure that no data is lost when multiple end users work on the same data, optimistic locking is used to prevent any overwrites of data that was edited by another user at the same time.
Responsive Form Layouts
Using a responsive grid, form pages can be designed to make optimal use of space on larger screens, while having forms items automatically be re-arranged for use on smaller devices, such as tablet and smartphone screens.
The Universal Theme UI for Oracle APEX has been designed from the very beginning to be fully responsive so that it works just as well on small screen as it does on larger ones.
This means that the UI components such as forms, charts, reports, and more will work seamlessly across varying screen resolutions while maintaining the same or similar functionality.
Pages and screens across your application will automatically adjust to render is the most optimal way based on your viewport size. Zero effort required.
Easily integrate touch gestures or use mobile-optimized ui patterns for navigation, page layouts, and many other components.
All components on your page are placed on top of a fluid grid system that gives you total control of the layout of your page.
Versatile UI Components
Universal Theme provides the components / building blocks necessary to build practically any type of business application UI.
From Cards, Forms, Menus, Tabs, Reports, and so much more, these components have been developed with the best practices following common and popular UI patterns. You can browse all of the components provided with Universal Theme by navigating to the Components section of this application.
Common UI Patterns
There are a multitude of components based on common and well understood design patterns readily available to be used within your app.
You can choose to use a tree-based navigation menu that displays to the side, a menu bar navigation near the top of the screen, or a mobile-optimized tabs display.
Live Template Options
Easily customize the appearance of any template-based component simply by making a selection or checking a box to get exactly the UI you want.
Even for the most basic of requirements, theming and customization is a key and necessary ingredient to the success of your application.
Feeling artistic? Open Theme Roller and style your application exactly the way you want. Define custom color schemes and other settings to be used across your application. All of this during runtime.
Not an artist? We've got you covered. There are a number of Theme Styles available out of the box for your selection. You can even configure the UI of your application programmatically and even allow users to set their own theme preference.
Have something very specific in mind? You can customize the UI of your application across the spectrum, from simple CSS overrides to building your own entirely bespoke theme and templates.
Font APEX is an entirely bespoke icon library designed in-house to complement Universal Theme. It contains over 1,100 distinct icons, 25 modifiers, and is available two families: Small and Large.
The tight integration of Universal Theme and Font APEX allows many components to automatically apply the large or small icons based on the styling context (such as Template Options). All you need to do is focus on the icon you want.
1100+ Handcrafted Icons
We take icons seriously. So we designed our own icon library to perfectly complement Universal Theme and Oracle APEX with over 1,100 distinct glyphs.
Two Families. One Library.
There are two families of icons in Font APEX: small and large. Small icons are based on a 16x16 grid and ideally suited for buttons and menus. Large icons are based on a 32x32 grid and well suited for places where you need to provide a larger graphic, such as cards, media lists, and hero regions.
You can easily customize each icon to apply rotations, animations, or even a modifier icon on top. Simply add the appropriate helper class to the icon, or use the built in Icon Builder in the Universal Theme app.
Oracle APEX is designed to build web apps that are highly secure out of the box. In a world of constantly changing web standards and increasingly resourceful attackers finding new ways to hack sites, our focus on security means that your applications stay protected.
Server-side session management for a user's interactions with an application is an intrinsic part of Oracle APEX.
Sessions are defined by a browser cookie value and an ID in the URL, which are long random values that an attacker can not guess to take over a user's session. Built-in timeouts guarantee that the session automatically terminates when a user is away for too long.
Item Session State
Application and page items save their values in session state, optionally in an encrypted form. Developers can access and manipulate the values in SQL and PL/SQL via bind variable syntax, which prevents SQL Injection.
Oracle APEX Collections are non-scalar, multi-row and multi-column session data. Developers can manage collections via PL/SQL APIs and views.
Secure By Default
While providing full control to developers, Oracle APEX generates applications with highly secure settings, right out of the box.
Parameter Tampering Protection
Oracle APEX uses checksums to prevent users from manipulating parameters in the URL and when saving changes. Attackers are not able to send their victims forged URLs that execute unwanted actions when clicked.
Cross-Site Scripting (XSS) occurs when attackers save malicious data in a web site and the site renders this data as code that executes in the user's browser. Oracle APEX components escape all output by default to prevent this class of attacks.
Advisor and other tools
Developers can run the Oracle APEX Advisor to check their applications for settings that make the application less secure, or inconsistencies that could be exploited by attackers. There are also third party tools available that offer extensive analysis of applications for vulnerabilities.
Oracle APEX is designed to make it as easy as possible for developers to build highly accessible web apps, that provide an inclusive user experience for users with different abilities and requirements. With every release, we strive to make this easier than ever, with new accessibility-specific functionality being added, known accessibility bugs being fixed, and ongoing improvement of our own testing strategies, all in the aim of providing a tool with a fantastic developer, and user experience for everybody.
Accessibility. Out of the box.
Oracle APEX is built with accessibility in mind at every point of the development cycle, from design through to delivery. One of the key aims is to provide out of the box accessibility wherever possible, such that an app built with the standard, default features of Oracle APEX should display a good degree of accessibility with minimal effort.
Accessible UI Components
Oracle APEX includes a comprehensive set of modern UI components, built to Oracle's accessibility guidelines.
Beautiful and accessible app theming with the Universal Theme. Easily customizable look and feel, for both developers and end-users through Theme Styles.
No modes required
Following modern guidelines now means we no longer require the use of accessibility modes to be accessible, making it even easier for both Oracle APEX developers and end users.
Although the framework will provide a good degree of accessibility out of the box, it is still the responsibility of the developer to ensure their Oracle APEX app truly provides a great experience for all users. We therefore provide some key functionality and resources to help you achieve this.
Accessibility checks built into the app Advisor, to allow you to identify some accessibility issues early in the development process. These include checks to identify page items without appropriate labelling, or pages with no page title.
Universal Theme Contrast Checking
Color contrast checks built into Theme Roller, allowing a designer to validate text contrast against WCAG 2.0 color contrast guidelines.
Fully documented Accessibility Guide, including a section dedicated to Developing Accessible Apps, guiding you though the points of the framework that affect accessibility.
So you need to address accessibility with your Oracle APEX apps and want to know more, perhaps in understanding what accessibility guidelines we follow, or the current known accessibility issues in the framework? Oracle provides all this key information for you.
Oracle Accessibility Guidelines
Built to the Oracle accessibility guidelines, for further information please visit Oracle's Accessibility Philosophy and Policies, under 'Guidelines and Standards'
Published Voluntary Product Accessibility Template (VPAT), describing how well we meet these guidelines, including details of significant defects.
With every release, we report any less significant known accessibility issues in our Release Notes. This will include bug numbers, and workarounds where possible.
Monitoring and logging provide insight into how users interact with your application. This information can be indispensable in identifying hacking attempts, performance issues and application errors. With Oracle APEX you are covered, because monitoring and logging are already built in.
Oracle APEX automatically logs events that occur when your application is used and developed. This information is stored in a rolling fashion, so old data automatically goes away after a period of time that administrators can control.
Application Runtime Activity
Oracle APEX logs login attempts, access to any page (including page rendering time) and access to remote web services.
Whenever a developer modifies an application, Oracle APEX stores the event for later auditing.
A varied collection of pre-defined reports are available, for example to check for errors, check for changes in application performance or to search for specific events that have taken place.
Code Instrumentation and Tracing
Oracle APEX can emit highly detailed diagnostic data, which can help in finding bugs or performance issues in applications. Administrators are able to enable diagnostic logging for specific user sessions, or for the whole instance. Developers have easy access to diagnostic output, with reporting pages available in the Oracle APEX development environment.
Debug Mode controls the level of diagnostic output, from 1 (errors) to 9 (Oracle APEX engine internal information). Developers can use the same instrumentation framework to add diagnostic code to their application code.
Development Cycle Integration
Developers can directly enable debug mode and see debug output for their test session, via the browser's developer toolbar.
Use SQL Trace to get execution plans and wait events for SQL statements.
Globalization is the ability of a development framework to support developing applications that perform well and correctly in a multiple languages and locales environment. Oracle APEX is designed with globalization in mind, this includes support for translating applications as well as localization, i.e. adapting an application to support a specific language and locale.
Translation allows running applications in multiple languages without having to duplicate the application logic.
Translatable Application Attributes
Most declarative attributes that define text such as page and region headings, field labels and column headings are automatically included when translating an application.
Translatable application attributes and messages are exported as an XLIFF file during translation. XLIFF is an standardized, XML-based format for passing translatable data between different tools.
Format and display content in the application based on where the end user is located.
Show numeric data with the appropriate decimal notation depending on the territory.
Time Zones and Territories
Render date and time data using the appropriate date and time format and automatically convert to the locale of the end user.
Render right-to-left languages automatically in the proper document direction when using the Universal Theme.