Features
Oracle APEX offers all the tools you need to be productive, deliver on time, and produce
stunning results for your business.
Data
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.
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.
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.
Flexible Editing
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.
Charting Capabilities
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.
Responsive
These charts are fully HTML5 capable and work on any modern browser, regardless of platform, screen size, or features.
Highly Customizable
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.
Extensive Range
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 Workshopm 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 API's. 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.
Automatic DML
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.
Optimistic Locking
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.
User Interface
Universal Theme is a user interface for Application Express that enables developers to build modern web applications without requiring extensive knowledge of HTML, CSS, or JavaScript. With some working knowledge of Application Express, you can use Universal Theme to easily build a responsive application that is highly accessible, easily customizable, and easy to maintain.
Absolutely Responsive
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.
Smart Layouts
Pages and screens across your application will automatically adjust to render is the most optimal way based on your viewport size. Zero effort required.
Mobile Friendly
Easily integrate touch gestures or use mobile-optimized ui patterns for navigation, page layouts, and many other components.
Grid Layout
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.
Application Navigation
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.
Easy Customization
Even for the most basic of requirements, theming and customization is a key and necessary ingredient to the success of your application.
With Universal Theme, you can effortlessly customize and fully control the look and feel of your applications without becoming an expert in UI design, HTML, CSS, or JavaScript. Using Theme Roller and Template Options, you can easily customize your application to fit your company's brand, and customize the look and feel of various components using Template Options. All of this is possible during runtime, so what you see is what you really get.
Theme Roller
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.
Theme Styles
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.
Live Complete Control
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.