Oracle APEX
Build apps fast,
right inside Oracle Database.
Oracle APEX (Application Express) is a low-code development platform included with Oracle Database. It lets you build business applications quickly while making use of SQL and PL/SQL skills. With no extra middleware or license fees, it is especially cost-effective if you already use Oracle Database.
What you can do with Oracle APEX
-
Included with Oracle Database
Use it with no extra middleware or license fees. If you already have Oracle Database, you can start developing right away.
-
Pages and forms by drag and drop
Design layouts, input forms and lists visually, assembling business apps with minimal code.
-
Advanced logic with SQL and PL/SQL
Use your existing SQL and PL/SQL assets and skills as they are, running even complex business logic quickly in the database.
-
Responsive UI, automatically
Screens adapt to PC, tablet and mobile automatically, saving the effort of adjusting for each device.
-
Automatic RESTful APIs
Database information is published automatically as RESTful APIs, making it easy to connect with external systems and other apps.
-
Hosting on Oracle Cloud (OCI)
It also runs on Oracle Cloud Infrastructure, so you can build and operate it on-premises or in the cloud.
Issues
Even with Oracle Database in place, do these challenges remain?
Cost and time limits keep you from building apps that use your Oracle data
The data is there, but front-end development to use it never gets started, so its value goes to waste.
You know SQL and PL/SQL, but lack front-end development expertise
You have database skills, but without know-how in screen development, you can’t take the step to building apps.
Business tools built on Excel macros depend on one person, and no one else can maintain them
Macros only one person understands are at the heart of the work, and a resignation or transfer could bring it to a halt.
Oracle APEX solves all of these at once.
Benefits
Turn your existing Oracle assets into apps, with ITSO.
Certified Oracle partner
ITSO officially provides Oracle implementation and development support, making full use of APEX’s latest features.
Low-cost start using your Oracle Database
If you already use Oracle Database, you can get started quickly with little extra license cost.
Building a team on your SQL and PL/SQL skills
We make the most of your database people, helping you set up in-house development with hands-on support.
Migration from Excel macros and Access tools
We map out Excel macros and Access apps that depend on individuals and plan their migration to APEX.
Oracle Cloud Infrastructure support
We help design and build with migration from on-premises to OCI and cloud operation in mind.
Maintenance and expansion after rollout
Ongoing remote support for app changes, new apps and performance tuning.
Flow
Three steps to go-live, in as little as two months.
-
1
Consultation and requirements
2–4 weeksWe organize requirements for the apps you want to build in-house and review your Oracle Database environment and data model.
-
2
App design and development
3–6 weeksWe build screens and logic in APEX, adding advanced PL/SQL processing as needed, with reviews and feedback along the way.
-
3
Testing, rollout and adoption
1–4 weeksAfter user testing, we roll out to production and keep supporting improvements and new features once it is running.
Scene
Oracle APEX is at work across a wide range of tasks that use Oracle Database.
-
Manufacturing
A shop-floor dashboard app built on production data
Production data stored in Oracle Database was delivered as a dashboard app that shop-floor staff can check easily.
-
Logistics
Inventory management moved from Excel to an APEX app
Inventory management in Excel macros that only one person could handle was rebuilt as an APEX business app, ending the dependence on that person.
-
IT department
Multiple business apps brought together in APEX
Small business apps scattered across departments were consolidated on APEX, centralizing operation and maintenance.
FAQ
-
Power Platform is strongest in Microsoft 365 environments and Salesforce in CRM, while Oracle APEX is ideal when you already use Oracle Database and want data-driven apps at little extra cost. It fits especially well with organizations that have SQL and PL/SQL assets and skills.
-
A single simple app can be built in 2–4 weeks. A standard implementation with complex business logic or several integrated apps takes about 2–3 months.
-
Yes. Existing tables, views and PL/SQL procedures can serve directly as your app’s data sources and logic. Think of it as building a new front end on top of your database assets.
-
Basic screens can be built by drag and drop, but SQL and PL/SQL knowledge lets you build more advanced apps with complex business logic. ITSO also proposes a development setup and training to match your skill level.
-
Oracle APEX itself is included with Oracle Database, so there is no extra license fee. We will explain Oracle Database licensing and the costs of running on Oracle Cloud individually, based on your environment.
